HCL Workload Automation, Version 9.4

Modifying the DB2 automatic maintenance policy

To know when and how the statistics used by the automatic maintenance must be collected, DB2® uses a default policy, which can be customized. The procedure is as follows:
  1. Right-click the database in the DB2 Control Center and select Configure Automatic Maintenance from the menu.
  2. Follow the instructions in the wizard, modifying any of the default policy parameters that you think might improve the way DB2 chooses when to run the automatic maintenance.