Viewing call level statistics for current activity

Follow these steps to view call level statistics for current activity.

Procedure

  1. On the DB2 Query Monitor main menu, type 3 in the Option field and press Enter.
  2. Locate the SQL activity for which you want to view call level statistics.
  3. Type C in the CMD field next to the SQL activity of interest and press Enter.
    The Call Level Statistics panel is displayed:
    Figure 1. Call Level Statistics panel
    YYYY/MM/DD HH:MM:SS  ------- Call Level Statistics ------  Row 1 of 3          
Option  ===> ________________________________________________ Scroll ===> PAGE 
                                                                               
 DB2 SSID: DB01   Plan: PLAN0001    DBRM: DBRM1  Coll: DSNTEP2               
                  Cursor: C1                  Section:       1                 
Filters Enabled: N    
CMD - Enter "/" to select action                                                         
------------------------------------------------------------------------     > 
CMD STMT#    DB2 CPU Time    DB2 Elapsed       GETPAGES SQLCODE   SQL Calls    
 -  ------ -------------- -------------- -------------- ------- -----------    
 _   1,683       0.006072       0.059150              0       0           1    
 _   1,631       0.000030       0.000030              0       0           1    
 _   1,619       0.000210       0.000310              0       0           1    
***************************** Bottom of Data **********************************