3.2.2 Set the database instance to auto-restart after abnormal termination

Information

The autorestart parameter specifies if the database instance should restart after an abnormal termination. It is recommended that this parameter be set to ON.

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

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 autorestart on
Default Value:
The default value for AUTORESTART is ON.

See Also

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