4.1.11 Set Archive Log Failover Retry Limit (NUMARCHRETRY)

Information

The NUMARCHRETRY parameter determines how many times a database will try to archive the log file to the primary or the secondary archive destination before trying the failover directory. It is recommended that this parameter be set to 5.

Rationale:

Establishing a failover retry time limit will ensure that the database will always have a means to recover from an abnormal termination. This parameter should not be set to 0.

Solution

Connect to the Db2 database

db2 => connect to <dbname>

Run the following command:

db2 => update database configuration using numarchretry 5

See Also

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