Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20100104004127 1 D S0000041.LOG C0000007

----------------------------------------------------------------------------

----------------------------------------------------------------------------

Comment:

Start Time: 20100104004127

End Time: 20100104004128

Status: A www.2cto.com

----------------------------------------------------------------------------

EID: 86 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000041.LOG

db2inst1@suse-db:~> db2 prune history 20100104004127 and delete

DB20000I The PRUNE command completed successfully.

db2inst1@suse-db:~> db2 list history archive log all for ggyy | head -20

List History File for ggyy

Number of matching file entries = 1

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20100104004127 1 D S0000041.LOG C0000007

----------------------------------------------------------------------------

----------------------------------------------------------------------------

Comment:

Start Time: 20100104004127

End Time: 20100104004128

Status: A www.2cto.com

----------------------------------------------------------------------------

EID: 86 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000041.LOG

db2inst1@suse-db:~> ls -l /data/palog/db2inst1/GGYY/NODE0000/C0000007/

total 24

-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:55 S0000038.LOG

-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-04 00:41 S0000041.LOG

S0000041.LOG依然存在，因为它是全备之后生成的。如果想要强制清除，可以使用 with force option 参数。

db2inst1@suse-db:~> db2 prune history 20100104004127 with force option and delete

DB20000I The PRUNE command completed successfully.

db2inst1@suse-db:~> db2 list history archive log all for ggyy | head -20

List History File for ggyy

Number of matching file entries = 0

db2inst1@suse-db:~> ls -l /data/palog/db2inst1/GGYY/NODE0000/C0000007/

total 12 www.2cto.com

-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:55 S0000038.LOG

注意，这里连带着将数据库全备的条目也删除了，但备份文件还在：

db2inst1@suse-db:/data/backup> db2 list history backup all for ggyy

List History File for ggyy

Number of matching file entries = 0

db2inst1@suse-db:/data/backup> ls -l /data/backup

total 99994

-rw------- 1 db2inst1 db2iadm1 102293504 2010-01-04 00:41 GGYY.0.db2inst1.NODE0000.CATN0000.20100104004121.001

此外，使用 db2 prune logfile 命令可以清除活动日志目录下的在线归档日志文件，但对离线归档日志文件无效，这里不再赘述。

作者 jackytang520