Customizing the minimum interval length

You can customize the minimum interval length that Db2 Query Monitor uses for reorganization recommendation using the com.rocketsoft.nm.qm.reorg.MinIntervalLength parameter in cqm.server.properties.

Procedure

  1. Open the cqm.server.properties file that is appropriate for your installation of the CAE server. If a cqm.server.properties does not exist, create one.
    • If your CAE server is installed on Windows, cqm.server.properties is located in the root folder of your CAE installation directory. If a cqm.server.properties file does not exist, create one.
    • If your CAE server is installed on USS, the cqm.server.properties file is in the CQM_VAR_HOME directory on USS.
  2. Add the com.rocketsoft.nm.qm.reorg.MinIntervalLength parameter with the appropriate value for your reorganization recommendation goals. For information about the com.rocketsoft.nm.qm.reorg.MinIntervalLength parameter, see CAE server properties (Windows).
  3. Save cqm.server.properties.