SUMMARY_VARIATION
Use the SUMMARY_VARIATION parameter in CQMPARMS to control the summary metrics collection behavior of your Query Monitor Subsystem.
- Description
- Collects standard deviation data in its summary metrics for workloads. To collect standard
deviation data, the Db2 subsystem of interest must be monitored with a monitoring profile. Important: If you are using Db2 Query Monitor in a data sharing environment, you must specify a consistent value for the SUMMARY_VARIATION parameter across all of the Query Monitor Subsystems that belong to the same data sharing group. If the Query Monitor Subsystems in a data sharing group do not use the same SUMMARY_VARIATION values, the StdDev values reported on the Summaries panel for the data sharing group will be inaccurate.
- Syntax
- SUMMARY_VARIATION(Y|N)
- Default
- N
- Valid values
-
- Y
- Collect standard deviation data in summary metrics for workloads.
- N
- (Default) Do not collect standard deviation data in summary metrics for workloads.
- Example
- SUMMARY_VARIATION(Y)