HCL Workload Automation, Version 9.4

Switching off automatic maintenance

If you want to take full manual control of the database, switch off the automatic maintenance as follows:
  1. Check that the user who is going to run the procedure has the appropriate rights (see User permissions for running the DB2 tools)
  2. On the DB2® server computer, open a DB2 shell, as follows:
    UNIX
    Follow these steps:
    1. 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)
    2. Launch the command . ./db2profile
    Windows
    Select from the Start menu, Programs → IBM DB2 → Command Line Tools → Command Window
  3. Check that the command shell is correctly initialized by issuing the command db2, and checking that the command is recognized.
  4. Issue the command quit to leave the DB2 Processor mode.
  5. Issue the following command:

    db2 UPDATE DB CFG FOR <database_name> USING AUTO_MAINT OFF

    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).

  6. To make the changes effective, either disconnect and reconnect all the DB2 clients, or restart the DB2 instance (using db2stop and db2start).