Information
Enable automatic database maintenance on your DB2 instance. It is recommended that the DB2 Automatic Maintenance tool be used to ensure that the instance is performing optimally.
A well-maintained DB2 instance will provide access to the data and reduce database outages.
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 auto_maint on
Default Value:
The default value for AUTO_MAINT is ON.