Switching on automatic maintenance
To turn the automatic maintenance back on again, do as follows:
- Check that the user who is going to run the procedure has the appropriate rights (see User permissions for running the DB2 tools)
- On the DB2® server computer, open a DB2 shell,
as follows:
- UNIX
- Follow these steps:
- Issue the command su - db2inst1, or change to the subdirectory sqllib of the home directory of the owner of the DB2 instance (by default db2inst1)
- Launch the command . ./db2profile
- Windows
- Select from the Start menu, Programs → IBM DB2 → Command Line Tools → Command Window
- Check that the command shell is correctly initialized by issuing the command db2, and checking that the command is recognized.
- Issue the command quit to leave the DB2 Processor mode.
- Issue the following command:
db2 UPDATE DB CFG FOR <database_name> USING AUTO_MAINT ON
where <database_name> is the name of the HCL Workload Automation database (the installed default name is TWS; supply this value unless you have changed it).
- To make the changes effective, either disconnect and reconnect all the DB2 clients, or restart the DB2 instance (using db2stop and db2start).