DB2参数REC_HIS_RETENTN

最新推荐文章于 2025-06-07 19:24:53 发布

原创最新推荐文章于 2025-06-07 19:24:53 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#db2 #database #delete #file #table

DB2 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了DB2的REC_HIS_RETENTN参数，用于设置备份历史信息保留的天数。建议值为30天左右，以保持文件大小在30M以内。该参数允许配置以控制恢复历史文件的存储，当不需要跟踪备份时可设置较小数值。同时提到了/prune历史记录的方法，并强调即使设置较短保留期，最近的完整数据库备份也会被保留，除非使用带有FORCE选项的PRUNE命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.