Viewing query activity data

For a selected subsystem or data sharing group, you can view query activity over a certain interval of time. You can view current activity, summaries, exceptions, SQL codes, and Db2® commands. You can then drill down on a particular line of data to view additional metrics.

Procedure

To view query activity data:
  1. From any window within the CAE browser client, click Activity Browser.
  2. In the Sources list, select CQM Subsystems to use a Query Monitor subsystem or select the archive connection that you want to use.
    Notice that you can also create a new archive connection or edit existing archive connections from this drop-down list.
  3. In the Target list, select your subsystem or data sharing group.

    Each subsystem is listed in the following format:

    [SYS:QMID] - SSIDs

    SYS
    The system (sysname)
    QMID
    The Query Monitor subsystem
    SSIDs
    The Db2® subsystem
    Note: In the CAE, the sysname of a system is its identifier. If you change the address (DNS name or IP address) of a system, but do not change the sysname, all new alerts associated with the sysname are considered to occur on the same system as the alerts that occurred on the system before the change. If you keep the address the same but change the sysname, it is considered a new system.

    Each data sharing group is listed in the following format:

    [DSGroup] - SSIDs

    DSGroup
    The data sharing group name
    SSIDs
    The Db2 subsystem
  4. Use the Intervals lists to select a starting and ending interval.

    To view and manage these intervals, click the Show Interval Manager button. See Managing intervals.

  5. Optional: In the Filters list, select the filter that you want to use.
    See Filters.
  6. In the Perspectives list, select one of the following perspectives:
    Summaries
    View and drill down through your system's query activity.

    If you select Summaries, you must specify a summary level, such as plan or program, in the adjacent drop-down list.

    Current Activity
    View active statements currently being executed by Db2.
    Exceptions
    View the exceptional events for your monitored Db2 subsystems.
    SQLCODES
    View SQL codes for your monitored Db2 subsystems. If you select SQLCODES, you must specify a category for grouping, such as plan or program, in the adjacent drop-down list.
    DB2 Commands
    View information about the execution of Db2 commands for your monitored Db2 subsystems.
  7. Click Run.
    The requested metrics are displayed in a data table. For a description of any column in the table, hover over the column header to display a tooltip with the column description.
  8. Optional: Drill down and navigate through the data as needed:
    • To navigate through intervals in a step-wise manner, either forwards or backwards, use the up and down buttons to the right of the Intervals lists. You do not need to click Run when using these up and down buttons; the action is immediately applied.
    • To drill down on a particular line of data, select a command in the Command list for that line.