hua812
作者hua8122010-09-10 15:00

REC_HIS_RETENTN

字数 1297阅读 671评论 0赞 0
update db cfg using REC_HIS_RETENTN nn
nn为您需要保留的天数
PRUNE HISTORY timestamp [WITH FORCE OPTION] [AND DELETE]

在这个目录下面: /db2inst1/NODE0000/SQL00001
下面有两个文件 db2rhist.asc / db2rhist.bak

建议将这个文件控制在30M以内,最好是20M左右
---------------------------------------------------------------------------------
rec_his_retentn - Recovery history retention period configuration parameter
Configuration Type Database Parameter Type Configurable Default [Range] 366 [ -1; 0 -- 30 000 ] Unit of Measure Days

This parameter is used to specify the number of days that historical information on backups should be retained. If the recovery history file is not needed to keep track of backups, restores, and loads, this parameter can be set to a small number.

8 If value of this parameter is -1, the number of entries indicating full database backups 8 (and any table space backups that are associated with the database backup) will correspond with the 8 value specified by the num_db_backups parameter. 8 Other entries in the recovery history file can only be pruned by 8 explicitly using the available commands or APIs.

No matter how small the retention period, the most recent full database backup plus its restore set will always be kept, unless you use the PRUNE utility with the FORCE option.


如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

  • DB2中的date转timestamp
    评论 0 · 赞 0
  • 数据库脏读带锁问题
    评论 0 · 赞 0
  • load问题
    评论 0 · 赞 0
  • AIX操作系统命令小结
    评论 0 · 赞 0
  • 一句话
    评论 0 · 赞 0
  • 关于TWT  使用指南  社区专家合作  厂商入驻社区  企业招聘  投诉建议  版权与免责声明  联系我们
    © 2019  talkwithtrend — talk with trend,talk with technologist 京ICP备09031017号-30