com.rocketsoft.nm.qm.reorg.metrics
Use the com.rocketsoft.nm.qm.reorg.metrics parameter in cqm.server.properties to control the smarter reorganization recommendation behavior of the CAE Server.
- Description
- The metrics and thresholds analyzed during reorganization recommendation. One or more metrics (and their corresponding thresholds) can be defined. A colon separates the metric and its values. A comma separates each metric/value set.
- Syntax
- com.rocketsoft.nm.qm.reorg.metrics=metric1:low_threshold%_1:absolute_threshold_1:threshold%_1,metric2:low_threshold%_2:absolute_threshold_2:threshold%_2
- metric1, metric2
- The metrics that are analyzed for reorganization recommendation. Valid metrics include columns in the CQM_SUMM_METRICS table.
- low_threshold%_1, low_threshold%_2
- The low threshold percentage is used to verify that sufficient data exists in the comparison performance window to analyze and to make a reorganization recommendation. The low threshold percentage is checked when recommendation is requested from Db2® Automation Tool.
- absolute_threshold_1, absolute_threshold_2
- The absolute threshold for a metric is used to verify that sufficient data exists in the performance window to analyze and to make a reorganization recommendation.
- threshold%_1, threshold%_2
- The threshold percentage for a metric is the percentage by which the metric differs as measured in the baseline performance window versus the comparison performance window. The threshold % is checked when recommendation is requested from Db2 Automation Tool.
- Default
- DB2_CPU:60:1:10,DB2_ELAPSED:60:10:20
- Example
- com.rocketsoft.nm.qm.reorg.metrics=GETPAGES:60:100:15