DB2删除冗余备份
对于装在虚拟机上面的测试机，归档日志等备份文件往往会因为疏于管理而逐渐塞满小小的硬盘使用prune命令可以智能的删除除最近备份外的冗余备份
Read syntax diagramSkip visual syntax diagram
>>-PRUNE-------------------------------------------------------->
>--+-HISTORY--timestamp--+-------------------+--+------------+-+-><
| '-WITH FORCE OPTION-''-AND DELETE-' |
'-LOGFILE PRIOR TO--log-file-name---------------------------'
因为是测试环境，所以偷懒一次过把所有的backup entries 删掉：
--设置auto_del_rec_obj
$ db2 update db cfg for sample using AUTO_DEL_REC_OBJ on
DB20000IThe UPDATE DATABASE CONFIGURATION command completed successfully.
--设置LOGARCHMETH1
$ db2 get db cfg for sample|grep First
First active log file = S0000015.LOG
First log archive method (LOGARCHMETH1) = DISK:/arch/
--进行备份
$ db2 backup db sample online to /tmp
Backup successful. The timestamp for this backup image is : 20111221185402
--备份前冗余的archive log
# ls -l
total 60
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:52 S0000015.LOG
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:52 S0000016.LOG
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:53 S0000017.LOG
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:53 S0000018.LOG
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:54 S0000019.LOG
--备份
$ db2 backup db sample online to /tmp
Backup successful. The timestamp for this backup image is : 20111221185402
--备份文件以及之前冗余的备份文件：
$ ls -tral SAMPLE*
-rw------- 1 db2inst1 db2iadm1 96555008 Dec 21 17:53 SAMPLE.0.db2inst1.NODE0000.CATN0000.20111221175310.001
-rw------- 1 db2inst1 db2iadm1 94515200 Dec 21 18:54 SAMPLE.0.db2inst1.NODE0000.CATN0000.20111221185402.001
--执行prune命令，时间点甚至可以是以后
$ db2 "prune history 201112221530 and delete"
DB20000IThe PRUNE command completed successfully.
--删除的效果：
--archive log：
# ls -l
total 12
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:54 S0000019.LOG
--backup image：
$ ls -tral SAMPLE*
-rw------- 1 db2inst1 db2iadm1 94515200 Dec 21 18:54 SAMPLE.0.db2inst1.NODE0000.CATN0000.20111221185402.001
--list history也相应被清空了
$ db2 list history archive log all for db sample
List History File for sample
Number of matching file entries = 1
Op Obj Timestamp+Sequence Type Dev Earliest Log Current LogBackup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
XD20111221185412 1 DS0000019.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20111221185412
End Time: 20111221185414
Status: A
----------------------------------------------------------------------------
EID: 42 Location: /arch/db2inst1/SAMPLE/NODE0000/C0000000/S0000019.LOG
参考：
ttp://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/c0051512.html
页:
[1]