4.1.3 Auto-restart After Abnormal Termination (AUTORESTART)

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/benchmarks/10752

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: Windows

Control ID: c1426498beaa02e958a7acd5941e5ba89e3af6d2cca4d91c419210ee6b7903eb