Configuring a Query Monitor subsystem

Configure your Query Monitor subsystem to collect the data you need to tune your SQL while using as few resources as possible.

Evaluating performance data
Performance data about your system can help you to determine the best monitoring profile settings, exception thresholds, and alert thresholds.
Customizing CQMPARMS
Db2® Query Monitor uses a set of parameters that define how Db2® Query Monitor is implemented, including the Query Monitor subsystem name, the monitored Db2® subsystems, and interval length. These parameters are stored in a data set allocated to the CQMPARMS DD statement in the Db2® Query Monitor JCL.
Monitoring profiles
A monitoring profile is a set of specifications that control how specific SQL workloads are monitored by Db2® Query Monitor. Creating a monitoring profile is an optional step in configuring your Query Monitor subsystem. Although not required, monitoring profiles are recommended for tailoring performance monitoring and alerts.

Parent topic: Getting started