银行db2 prune

db2 prune 删除日志不成功?

db2inst1@sles11:~> db2 connect to zzdb1   Database Connection Information Database server        = DB2/LINUXX8664 9.5.10 SQL authorization ID   = DB2INST1 Local database alias   = ZZDB1db2in...显示全部
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 delete
DB20000I  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.LOG
DB20000I  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收起
参与13

查看其它 11 个回答yuan23的回答

yuan23yuan23数据库管理员中科软科技股份有限公司
有时候删除日志是删除不掉,只能删除最近的几个,一般都是直接rm
系统集成 · 2014-07-15
浏览1734

回答者

yuan23
数据库管理员中科软科技股份有限公司

yuan23 最近回答过的问题

回答状态

  • 发布时间:2014-07-15
  • 关注会员:1 人
  • 回答浏览:1734
  • X社区推广