Db2 Query Monitor main menu

Use the Db2® Query Monitor main menu to access the main functions in this product.

Execute the Db2 Query Monitor CLIST to access the Db2 Query Monitor main menu:

Figure 1. Db2 Query Monitor main menu

YYYY/MM/DD HH:MM:SS ---- IBM DB2 Query Monitor for z/OS -----------------------
Option  ===> __________________________________________________________________
                                                                               
 Query Monitor Target: QM01____ (? to Select)                User: USERID    
                                                            Release: CQM V3R4M0 
-------------------------------------------------------------------------------
                                                                               
  0.  Settings                                                                 
  1.  View Activity Summaries            2. View SQLCODEs                      
  3.  View Current Activity              4. View DB2 Command Activity          
  5.  View Exceptions                                                          
                                                                               
  6.  Work with Monitoring Agents        7. Setup                              
  8.  Work with Profiles                 9. Exit Query Monitor                 
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
Enter END command to return to ISPF.

The main menu has the following fields:

Query Monitor Target: The Query Monitor subsystem ID being used with the current ISPF session. You can either type a Query Monitor subsystem ID directly into this field or select from a list of available Query Monitor subsystems. Enter ? in this field to select a Query Monitor subsystem from a list.
User: The user ID of the user who is currently operating the product.
Release: The version and release of Db2 Query Monitor currently running.

The main menu provides the following options:

0 - Settings

Specify the following product settings:

ISPF dialog options, such as whether to allow letter-style options, issue sort warnings, unstack to prior level in summaries, or dump on first error.
The plan that Db2 Query Monitor is to use to launch Db2 Admin Tool
The schema that Db2 Query Monitor is to use to call the Db2 Admin Tool stored procedure ADB2FMP.

1 - View Activity Summaries

Access and refine your view of your system's query activity.

2 - View SQLCODEs

View the expanded text description for an SQLCODE that is supplied by the IBM® utility program DSNTIAR.

3 - View Current Activity

Display active statements that Db2® is currently executing.

4 - View DB2 Command Activity

View information about the execution of Db2 commands throughout monitored systems.

5 - View Exceptions

View collected information about your system's SQL-related exceptional events (SQL text, object details, lock events, delay events, calls, and buffer pools).

6 - Work with Monitoring Agents

Activate and deactivate monitoring agents for the current Query Monitor subsystem. View, change, or refresh the monitoring profiles associated with monitoring agents.

7 - Setup

Specify system parameters such as the Db2 control file, Db2 Query Monitor plan, ZPARM, BSDS, and load library information.

8 - Work with Profiles

Create new monitoring profiles. Copy, update, rename, or view existing monitoring profiles.

9 - Exit Query Monitor

Exit Db2 Query Monitor.

The main menu supports the following commands:

CLEARCAE: Clear the previously selected CAE server. After issuing the CLEARCAE command, you can access the CAE Selection panel and select another CAE server by typing a ? in the Query Monitor Target field.