查看備份記錄
list history backup all for database DB_Names
=====================================================
List History File for a020db
Number of matching file entries = 3
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20061103110728001 F D S0000010.LOG S0000014.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP A020DB OFFLINE
Start Time: 20061103110728
End Time: 20061103115810
----------------------------------------------------------------------------
00001 Location: d:\A020DB.0\DB2\NODE0000\CATN0000\20061103
=====================================================
將 Earliest Log 之前的紀錄殺掉
查看當前使用記錄
get db cfg for DB_Name
看使用中log => active log
清除log
prune logfile piror s000009.log (s000010.log - 1 )
或者直接 rm
沒有留言:
張貼留言