num_db_backups - Number of database backups configuration parameter
This parameter specifies the number of full database backups to retain for a database.
- Configuration type
- Database
- Parameter type
- Configurable online
- Propagation class
- Transaction boundary
- Default [range]
- 12 [1 - 32 767]
After the specified number of full database backups is reached, old backups are marked as expired
in the recovery history file. Recovery history file entries for the table space backups and load
copy backups that are related to the expired database backup are also marked as expired. When a
backup is marked as expired, the physical backups can be removed when the following storage media
are used:
- Disk
- Storage manager such as IBM® Storage Protect
- Remote storage, such as IBM or Amazon Simple Storage Service (S3)
The next database backup prunes the expired entries from the recovery history file.
The rec_his_retentn configuration parameter should be set to a value compatible with the value of num_db_backups. For example, if num_db_backups is set to a large value, the value for rec_his_retentn should be large enough to support the number of backups set as num_db_backups.
If both the num_db_backups and rec_his_retentn configuration parameters are set, backups are not removed unless both the num_db_backups and rec_his_retentn conditions are satisfied.