4.1.10 Establish Retention Set Size for Backups (NUM_DB_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 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

See Also

https://workbench.cisecurity.org/benchmarks/10752

Item Details

Category: CONTINGENCY PLANNING

References: 800-53|CP-9, 800-53|CP-10, CSCv7|10.1

Plugin: Windows

Control ID: ab21eae552c18eb10418b5810d89f90441d515127db189588d4ed82e18c7ff5a