3.1.14 Set failed archive retry delay

Information

The archretrydelay parameter specifies the number of seconds the DB2 service will wait before it reattempts to archive log files after a failure. It is recommended that this parameter be set anywhere in the range of 10-30. You do not want the delay to be so short that the database ends up in a denial of service scenario, but you don't want the delay to be too long if an outside attack happens at the same time.

Solution

1. Connect to the DB2 database
db2 => connect to $DB2DATABASE user $USERNAME using $PASSWORD
2. To successfully set the archretrydelay within the 10-30 range, run the following command from the DB2 command window-
db2 => update database configuration using archretrydelay nn (where nn is a range between 10-30)
Default Value - The default value for archretrydelay is 20

See Also

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

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b., CSCv6|3.1

Plugin: Windows

Control ID: c3a6dfc0d61707196af158b0e9ec405fa77f448910143a021f90a6d1d4410a61