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.