db2inst1@sles11:~> db2 connect to zzdb1
Database Connection Information
Database server = DB2/LINUXX8664 9.5.10
SQL authorization ID = DB2INST1
Local database alias = ZZDB1
db2inst1@sles11:~> db2 get db cfg | grep -i reten
Recovery history retention (days) (REC_HIS_RETENTN) = 366
db2inst1@sles11:~> db2 get db cfg | grep -i num_db_backup
Number of database backups to retain (NUM_DB_BACKUPS) = 12
db2inst1@sles11:~> db2 get db cfg | grep -i auto_del
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = ON
db2inst1@sles11:~> db2 list history archive log all for zzdb1
List History File for zzdb1
Number of matching file entries = 3
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D
20140505172647 1 D S0000000.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20140505172647
End Time: 20140505174903
Status: A
----------------------------------------------------------------------------
EID: 2 Location: /db2log/db2inst1/ZZDB1/NODE0000/C0000000/S0000000.LOG
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20140610082458 1 D S0000001.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20140610082458
End Time: 20140610083155
Status: A
----------------------------------------------------------------------------
EID: 6 Location: /db2log/db2inst1/ZZDB1/NODE0000/C0000000/S0000001.LOG
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20140625213242 1 D S0000002.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20140625213242
End Time: 20140625223001
Status: A
----------------------------------------------------------------------------
EID: 7 Location: /db2log/db2inst1/ZZDB1/NODE0000/C0000000/S0000002.LOG
--删除20140508之前的log
db2inst1@sles11:~>
db2 prune history 20140508 and deleteDB20000I The PRUNE command completed successfully.
--1--删除不成功,为什么呀?
db2inst1@sles11:~> ll /db2log/db2inst1/ZZDB1/NODE0000/C0000000
total 272
-rw-r----- 1 db2inst1 db2iadm1 241664 May 5 17:49 S0000000.LOG
-rw-r----- 1 db2inst1 db2iadm1 20480 Jun 10 08:31 S0000001.LOG
-rw-r----- 1 db2inst1 db2iadm1 12288 Jun 25 22:30 S0000002.LOG
db2inst1@sles11:~> db2 list history archive log all for zzdb1
List History File for zzdb1
Number of matching file entries = 3
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20140505172647 1 D S0000000.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20140505172647
End Time: 20140505174903
Status: A
----------------------------------------------------------------------------
EID: 2 Location: /db2log/db2inst1/ZZDB1/NODE0000/C0000000/S0000000.LOG
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20140610082458 1 D S0000001.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20140610082458
End Time: 20140610083155
Status: A
----------------------------------------------------------------------------
EID: 6 Location: /db2log/db2inst1/ZZDB1/NODE0000/C0000000/S0000001.LOG
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
X D 20140625213242 1 D S0000002.LOG C0000000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Comment:
Start Time: 20140625213242
End Time: 20140625223001
Status: A
----------------------------------------------------------------------------
EID: 7 Location: /db2log/db2inst1/ZZDB1/NODE0000/C0000000/S0000002.LOG
========================================================================
db2inst1@sles11:~> db2 get db cfg | grep -i logre
Log retain for recovery enabled (LOGRETAIN) = OFF
db2inst1@sles11:~> db2 get db cfg | grep -i logarchmeth1
First log archive method (LOGARCHMETH1) = DISK:/db2log/
--删除 S0000002.LOG之前的日志
db2inst1@sles11:~>
db2 prune logfile prior to S0000002.LOGDB20000I The PRUNE command completed successfully.
--2--删除不成功,为什么呀?
db2inst1@sles11:~> ll /db2log/db2inst1/ZZDB1/NODE0000/C0000000
total 272
-rw-r----- 1 db2inst1 db2iadm1 241664 May 5 17:49 S0000000.LOG
-rw-r----- 1 db2inst1 db2iadm1 20480 Jun 10 08:31 S0000001.LOG
-rw-r----- 1 db2inst1 db2iadm1 12288 Jun 25 22:30 S0000002.LOG
收起