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.