4.1.3 Auto-restart After Abnormal Termination (AUTORESTART)

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

The AUTORESTART parameter specifies if the database manager will start a crash recovery automatically when the first user tries to connect to a database which has previously terminated abnormally.

If the parameter is set to OFF an explicit RESTART DATABASE command has to be issued to initiate a crash recovery.

It is recommended that this parameter is set to ON (which is also the default).

Rationale:

Setting the database to auto-restart will reduce the downtime of the database.

Solution

Connect to the Db2 database

db2 => connect to <dbname>

Run the following command:

db2 => update database configuration using autorestart on



Default Value:

The default value for AUTORESTART is ON.

See Also

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