注册登录
提 问
English中文版
银行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   = 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
关注1
评论
参与13

12同行回答
|
按赞同排序
按时间排序

yuan23yuan23数据库管理员中科软科技股份有限公司
有时候删除日志是删除不掉，只能删除最近的几个，一般都是直接rm显示全部
有时候删除日志是删除不掉，只能删除最近的几个，一般都是直接rm收起
系统集成 · 2014-07-15
浏览1752
评论
ydliujiangydliujiang数据库管理员IBM
回复 7# fjzcau    加force 参数会删不掉？显示全部
回复 7# fjzcau


   加force 参数会删不掉？收起
金融其它 · 2014-07-08
浏览1686
评论
fjzcaufjzcau系统运维工程师金融
db2inst2@sles11:~/db2inst2/NODE0000/SQL00001/SQLOGDIR> db2 update db cfg using LOGARCHMETH1 LOGRETAIN DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.SQL1363W  One or more of the parameters submitted for...显示全部
db2inst2@sles11:~/db2inst2/NODE0000/SQL00001/SQLOGDIR> db2 update db cfg using LOGARCHMETH1 LOGRETAIN
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W  One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.



--重新activate testdb 后

db2inst2@sles11:~/db2inst2/NODE0000/SQL00001/SQLOGDIR> db2 get db cfg | grep -i LOGRETAIN
Log retain for recovery enabled             (LOGRETAIN) = RECOVERY
First log archive method                (LOGARCHMETH1) = LOGRETAIN

db2inst2@sles11:~/db2inst2/NODE0000/SQL00001/SQLOGDIR> ls
db2inst2      S0000015.LOG  S0000018.LOG  S0000021.LOG  S0000024.LOG
S0000013.LOG  S0000016.LOG  S0000019.LOG  S0000022.LOG  S0000025.LOG
S0000014.LOG  S0000017.LOG  S0000020.LOG  S0000023.LOG  S0000026.LOG

--删除S0000014.LOG  之前的归档日志 成功
db2inst2@sles11:~/db2inst2/NODE0000/SQL00001/SQLOGDIR> db2 prune logfile prior to S0000014.LOG
DB20000I  The PRUNE command completed successfully.

db2inst2@sles11:~/db2inst2/NODE0000/SQL00001/SQLOGDIR> ls
db2inst2      S0000016.LOG  S0000019.LOG  S0000022.LOG  S0000025.LOG
S0000014.LOG  S0000017.LOG  S0000020.LOG  S0000023.LOG  S0000026.LOG
S0000015.LOG  S0000018.LOG  S0000021.LOG  S0000024.LOG收起
银行 · 2014-07-07
浏览1941
评论
stevenluffystevenluffyDBAIBM
回复 6# fjzcau     写错了。显示全部
回复 6# fjzcau


    写错了。收起
证券 · 2014-07-07
浏览1982
评论
fjzcaufjzcau系统运维工程师金融
回复 4# huangdk DB2归档删除确实不方便，不像oracle，备份完的归档日志可以自动删除。db2inst1@sles11:~> db2 get db cfg for zzdb1 | grep -i "first active" First active log file                   ...显示全部
回复 4# huangdk

DB2归档删除确实不方便，不像oracle，备份完的归档日志可以自动删除。
db2inst1@sles11:~> db2 get db cfg for zzdb1 | grep -i "first active"
First active log file                                   = S0000003.LOG


主要是考虑在生产备份归档如何删除的问题，可以通过脚本，但不也得判断一下 First active log 吗？收起
银行 · 2014-07-07
浏览1909
评论
fjzcaufjzcau系统运维工程师金融
不管怎样，有通过prune删除归档日志成功的，方法分享一下，多谢。实践最重要。显示全部
不管怎样，有通过prune删除归档日志成功的，方法分享一下，多谢。
实践最重要。收起
银行 · 2014-07-07
浏览1992
评论
fjzcaufjzcau系统运维工程师金融
回复 3# ydliujiang Recovery history retention (days)     (REC_HIS_RETENTN) = 5Number of database backups to retain   (NUM_DB_BACKUPS) = 2上面的参数我改过，也重启过，一样不行的。我发贴时这些都考虑过。有实践成功的，发帖分享一下...显示全部
回复 3# ydliujiang

Recovery history retention (days)     (REC_HIS_RETENTN) = 5
Number of database backups to retain   (NUM_DB_BACKUPS) = 2


上面的参数我改过，也重启过，一样不行的。我发贴时这些都考虑过。
有实践成功的，发帖分享一下吧，谢谢。收起
银行 · 2014-07-07
浏览1940
评论
fjzcaufjzcau系统运维工程师金融
回复 5# stevenluffy 看清楚语法哦。有实践成功的，分享一下。显示全部
回复 5# stevenluffy

prune_command.png



看清楚语法哦。
有实践成功的，分享一下。收起
银行 · 2014-07-07
浏览1908
评论
stevenluffystevenluffyDBAIBM
db2 prune logfile prior to S0000002.LOG with force option and delete显示全部
db2 prune logfile prior to S0000002.LOG with force option and delete收起
证券 · 2014-07-07
浏览1918
评论
huangdkhuangdk数据库架构师IBM
从来不用这个的路过显示全部
从来不用这个的路过收起
IT咨询服务 · 2014-07-07
浏览1902
评论

提问者

fjzcau
fjzcau
系统运维工程师金融
擅长领域： 云计算，容器，容器云
关注2
回答32
评论126

问题状态

  • 发布时间：2014-07-07
  • 关注会员：1 人
  • 问题浏览：16240
  • 最近回答：2014-07-15

    • 关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
    © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30

    X社区推广