Features and benefits

Db2 Query Monitor includes numerous features and benefits to help you monitor SQL queries across your Db2 for z/OS® environment.

Features

Db2 Query Monitor enables you to:

  • Collect, summarize, and display SQL resource consumption down to the level of the individual SQL text statement.
  • Collect, summarize, and display Db2 object access statistics down to the individual table and index.
  • Access data from multiple Query Monitor Subsystems using the CAE Server and TCP/IP.
  • View data from the perspective of a data sharing group.
  • View active SQL statements that are currently being executed by Db2.
  • Capture the full text of long SQL statements.
  • Disable summary reporting for specific workloads, include or exclude specific -SQLCODES from exception or alert processing, set exception limits and thresholds, and define alert notification thresholds.
  • View the expanded text description for an SQLCODE that is supplied by the IBM® utility program DSNTIAR.
  • View information about the Db2 commands that are executed on monitored Db2 subsystems.
  • Collect information relating to exceptional SQL-related events.
  • Configure proactive notification to alert users of problems.
  • Automate curative actions to deal with exceptional events as they occur.
  • Access consolidated data and events for Db2 subsystems, whether within a single z/OS image or across multiple Db2 images, independent of the existence of a coupling facility.
  • View and configure monitoring across your enterprise from a single console.

Benefits

Db2 Query Monitor provides the following benefits:

  • Scalable over the full range of Db2 installations.
  • Operates seamlessly in sysplex and stand-alone environments.
  • Supports single-console viewing of enterprise-wide Db2 SQL and object access activity.