9.7 Database Configuration Parameters

When a FULL backup is run DB2 can delete the oldest history records and archive log files.
This is governed by 3 database parameters, e.g. for database ED1

$ db2 get db cfg for ed1
...
Number of database backups to retain   (NUM_DB_BACKUPS) = 12
Recovery history retention (days)     (REC_HIS_RETENTN) = 60
Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF
...

Note that the automatic deletion of recovery objects (history and archive logs) is currently OFF.

Setting this to ON is supported by SAP

9.7 Doc
Number of days that historical information on backups will be retained

9.7 Doc
Number of database backups to retain for a database.
This needs to be compatible with REC_HIS_RETENTN
e.g. If we do a daily backup and we want to keep 12 days backups then REC_HIS_RETENTN must be set to at least 12.

9.7 Doc
Automatically prune history and archive log files after every FULL database backup based on the values of other two param's.

The database manager can only delete recovery objects such as database logs, backup images, etc. when your storage media is disk, or if you are using a storage manager such as the TSM.