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 **********************************