auto_del_rec_obj - Automated deletion of recovery objects configuration parameter
This parameter specifies whether to delete database log files, backup images, and load copy images when their corresponding recovery history entry is removed.
- Configuration type
- Database
- Parameter type
- Configurable online
- Propagation class
- Immediate
- Default [range]
- OFF [ON; OFF ]The database manager can delete recovery objects such as database log files, backup images, and load copy images when these storage media are used:
- Disk
- Storage manager, such as the Tivoli® Storage Manager (TSM)
- Remote storage, such as IBM® or Amazon Simple Storage Service (S3)
There is one limitation, when the logarchmeth1 database configuration parameter is set to LOGRETAIN, the database log files are not deleted from the active log path, when the associated recovery history file entries for these log files are pruned.
You can prune the entries in the recovery history file by using the PRUNE HISTORY command or the db2Prune API. You can also configure the IBM® Data Server database manager to automatically prune the recovery history file after each full database backup. If you set the auto_del_rec_obj database configuration parameter to ON, then the database manager deletes the corresponding physical log files, backup images, and load copy images when it prunes the history file.