DB2删除冗余备份

对于装在虚拟机上面的测试机，归档日志等备份文件往往会因为疏于管理而逐渐塞满小小的硬盘

使用prune命令可以智能的删除除最近备份外的冗余备份

Read syntax diagramSkip visual syntax diagram
>>-PRUNE-------------------------------------------------------->

>--+-HISTORY--timestamp--+-------------------+--+------------+-+-><
   |                     '-WITH FORCE OPTION-'  '-AND DELETE-' |   
   '-LOGFILE PRIOR TO--log-file-name---------------------------'   

因为是测试环境，所以偷懒一次过把所有的backup entries 删掉：
[code="sql"]
--设置auto_del_rec_obj
[db2inst1@test64bit00 tmp]$ db2 update db cfg for sample using AUTO_DEL_REC_OBJ on
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
--设置LOGARCHMETH1
[db2inst1@test64bit00 tmp]$ db2 get db cfg for sample|grep First
First active log file = S0000015.LOG
First log archive method (LOGARCHMETH1) = DISK:/arch/
--进行备份
[db2inst1@test64bit00 tmp]$ 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

--备份
[db2inst1@test64bit00 tmp]$ db2 backup db sample online to /tmp

Backup successful. The timestamp for this backup image is : 20111221185402

--备份文件以及之前冗余的备份文件：
[db2inst1@test64bit00 tmp]$ 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命令，时间点甚至可以是以后
[db2inst1@test64bit00 tmp]$ db2 "prune history 201112221530 and delete"
DB20000I The PRUNE command completed successfully.

--删除的效果：
--archive log：
# ls -l
total 12
-rw-r----- 1 db2inst1 db2iadm1 12288 Dec 21 18:54 S0000019.LOG

--backup image：
[db2inst1@test64bit00 tmp]$ ls -tral SAMPLE*
-rw------- 1 db2inst1 db2iadm1 94515200 Dec 21 18:54 SAMPLE.0.db2inst1.NODE0000.CATN0000.20111221185402.001


--list history也相应被清空了
[db2inst1@test64bit00 tmp]$ 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 Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20111221185412 1 D S0000019.LOG C0000000
----------------------------------------------------------------------------

----------------------------------------------------------------------------
Comment:
Start Time: 20111221185412
End Time: 20111221185414
Status: A
----------------------------------------------------------------------------
EID: 42 Location: /arch/db2inst1/SAMPLE/NODE0000/C0000000/S0000019.LOG
[/code]


参考：

[url]ttp://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/c0051512.html[/url]