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
$