5.3 Enable automatic database maintenance

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.

See Also

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