Viewing miscellaneous statistics

Follow these steps to view miscellaneous statistics.

Procedure

  1. On the DB2 Query Monitor main menu, type 1 in the Option field and press Enter.
  2. Select the appropriate summary level.
  3. Locate the SQL activity for which you want to view lock information.
  4. Type Q in the CMD field next to the SQL activity of interest and press Enter.
    The Miscellaneous Statistics panel is displayed:
    Figure 1. Miscellaneous Statistics panel
    YYYY/MM/DD HH:MM:SS  ------ Miscellaneous  Statistics ------  Row 1 of 39     
    Option  ===> ________________________________________________ Scroll ===> PAGE
    Filters Enabled: N  
    NAVI:   DB2(ST):DB01                                          
    ------------------------------------------------------------------------
    Event                                  Time/Count                       
    Trigger Elapsed Time                     0.000000                       
    Trigger DB2 CPU Time                     0.000000                       
    UDF Application Elapsed Time             0.000000                       
    UDF Application CPU Time                 0.000000                       
    UDF DB2 Elapsed Time                     0.000000                       
    UDF DB2 CPU Time                         0.000000                       
    SP Application Elapsed Time              0.000000                       
    SP Application CPU Time                  0.000000                       
    SP DB2 Elapsed Time                      0.000000                       
    SP DB2 CPU Time                          0.000000                       
    RIDLIST Used                                   21                       
    RIDLIST Failed - No Storage                     0                       
    RIDLIST Failed - Limit Exceeded                 0                       
    Groups Executed                                 0                       
    Sequential Cursor                               0                       
    Sequential No ESA Sort                          0                       
    Sequential No Buffer                            0                       
    Ran Reduced                                     0                       
    Ran as planned                                  0                       
    Procedure Abends                                0                       
    Call Timeout                                    0                       
    Call Reject                                     0                       
    Sequential Enclave Services                     0                       
    One DB2 Coordinator No                          0                       
    One DB2 Isolation Level                         0                       
    Reoptimization                                  0                       
    Prep Statement Matched                          0                       
    Prep Statement No Match                         0                       
    Implicit Prepares                               0                       
    Prep From Cache                                 0                       
    Cache Limit Exceeded                            0 
    Prep Statement Purged                           0 
    ROWID Direct Access                             0 
    ROWID Index Used                                0 
    ROWID TS Scan Used                              0 
    Statement Trigger                               0 
    Row Trigger                                     0 
    Trigger SQL Error                               0 
    Log Records Written                             0 
    Log Bytes Written                               0                            
    ***************************** Bottom of Data *********************************