Automating backup image pruning for Db2 databases running automatic backups

When a Db2 database is configured to run automatic backups, the management of the automatic backup path depends on the value of the auto_del_rec_obj database configuration parameter.

Legacy Pruning

When the auto_del_rec_obj database configuration parameter is set to OFF, only the latest backup image in the automatic backup directory is retained.

This legacy pruning is triggered before an automatic backup is taken. As a result, the path of a successful automatic backup contains no more than two backup images. These rules apply only when the backup target type that is configured in the automatic backup policy file is either DISK or REMOTE_STORAGE. No pruning takes place when the backup target type is not DISK or REMOTE_STORAGE.

Standard pruning

When the auto_del_rec_obj database configuration parameter is set to ON, the pruning of the automatic backup path respects the rules of the standard database pruning. To learn more about these rules, see Automating recovery history file pruning.