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 ensuring that all logs and transactions can be used for auditing.
Solution
Connect to the Db2 database
db2 => connect to <dbname>
Run the following command:
db2 => update database configuration using num_db_backups 12