Working with monitoring agents

Set up a monitoring agent to be used by your Query Monitor subsystem to collect data about your monitored Db2® subsystems.

If one Query Monitor subsystem task is performing data collections on three different Db2 subsystems, then there are three monitoring agents active for that Query Monitor subsystem. Additionally, each monitoring agent can optionally be assigned a monitoring profile.

When a monitoring agent detects SQL activity for a monitored Db2 subsystem, it refers to the monitoring profile (if one has been assigned to the monitoring agent ) and in turn to include/exclude monitoring profile lines, in the order in which they are listed on the Create Monitoring Profiles panel. Once a match is identified, Db2® Query Monitor proceeds as set forth in the matched monitoring profile line (to include or exclude the activity in question) and no further monitoring profile lines are considered for that unit of activity after the match occurs.

Thus, for monitoring agents that are assigned monitoring profiles, the proper configuration of the monitoring profile is a critical step in the successful monitoring of a system's queries.

Before you can activate a monitoring agent for a Db2 subsystem, the Db2 subsystem must be defined to the Db2 Query Monitor Db2 control file by using main menu option 7. Setup or by using Tools Customizer to generate CQM#CTLF. If you are using other products to monitor the same Db2 subsystem, you should review the considerations in Compatible releases and maintenance levels.