db2开启文件删除功能

Automating database recovery object management:
–If AUTO_DEL_REC_OBJ database CFG is ON, then in addition to
pruning entries from the recovery history DB2 will do the following:
  Delete the physical log files associated with the pruned entries
  Delete the backup images associated with the pruned entries
  Delete the load copy images associated with the pruned entries
–Automatic deletion of unneeded recovery objects performed after every full database backup operation.
–If there are more successful database backup entries than the num_db_backups configuration parameter, DB2 will automatically prune recovery history file entries that are older than rec_his_retentn.
–If there are no database level backups in the recovery history then images older than the range of time specified by rec_his_retentn will be deleted.

The AUTO_DEL_REC_OBJ database configuration parameter prunes log files,backup images and load copy files if NUM_DB_BACKUPS and REC_HIS_RETENTN conditions are met.

$ db2 get db cfg for sample | grep -i auto_del
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF
$ db2 get db cfg for sample | grep -i num_db
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12
$ db2 get db cfg for sample | grep -i rec_his
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366
$

请使用浏览器的分享功能分享到微信等