3.2.8 Establish retention set size for backups

Information

The num_db_backups parameter specifies the number of backups to retain for a database before marking the oldest backup as deleted. It is recommended that this parameter be set to at least 12.
Rationale:
Retain multiple copies of the database backup to ensure that the database can recover from an unexpected failure. This parameter should not be set to 0. Multiple backups should be kept to ensure that all logs and transactions can be used for auditing.

Solution

1. Connect to the DB2 database
db2 => connect to $DB2INSTANCE user $USERNAME using $PASSWORD
2. Run the following command from the DB2 command window:
db2 => update database configuration using num_db_backups 12
Default Value:
The default value for NUM_DB_BACKUPS is 12.

See Also

https://workbench.cisecurity.org/files/1654