Customizing metrics and thresholds

You can customize the metrics and thresholds that Db2® Query Monitor uses for reorganization recommendation by specifying the appropriate parameter. Follow the instructions that apply to your installation of the CAE server (on Windows® or on USS).

Procedure

1. If your CAE server is installed on Windows:
   1. In the root folder of your CAE installation directory, open the cqm.server.properties file for editing. If a cqm.server.properties file does not exist, create one.
   2. Add the com.rocketsoft.nm.qm.reorg.metrics parameter. For information about the com.rocketsoft.nm.qm.reorg.metrics parameter, see CAE server properties (Windows).
2. If your CAE server is installed on USS:
   1. Edit the CAE server started task (CQMCAESV).
   2. Add the CQM_REORG_METRICS parameter in the STDENV DD. For information about the CQM_REORG_METRICS parameter, see CAE server parameters (USS).