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.