3.2.9 Set archive log failover retry limit

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.

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

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 numarchretry 5
Default Value:
The default value for numarchretry is 5.

See Also

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