Viewing buffer pool statistics for an exception

Follow these steps to view buffer pool statistics for an exception.

Procedure

  1. On the DB2 Query Monitor main menu, type 5 in the Option field and press Enter.
  2. Locate the exception for which you want to view buffer pool statistics.
  3. Type B in the CMD field next to the SQL activity of interest and press Enter.
    Figure 1. Buffer Pool Statistics panel
    YYYY/MM/DD HH:MM:SS  ------ Buffer Pool Statistics ------  Row 1 of 16   
    Option  ===> ________________________________________________ Scroll ===> PAGE
                                                                                  
    DB2 SSID: QM01   Plan: DISTSERV   DBRM: SYSLHXXX  Coll: NULLID
                     Cursor: SQL_CURSOR1      Section:       1 
                     Accel:                                       
    ------------------------------------------------------------------------    + 
    Buffer Pool: ALL                                 Total          Average       
         Buffer Pool Hit Ratio (%)                   N/A            69.77         
         Hiper Pool Hit Ratio (%)                    N/A           100.00         
         Get Page Requests                         2,388            12.24         
         Buffer Pages Updated                        180             0.92         
         Synchronous Pages Read                        7             0.03         
         Synchronous Pages Written                     0             0.00         
         Sequential Prefetch Requests                 86             0.44         
         List Prefetch Requests                        0             0.00         
         Dynamic Prefetch Requests                    40             0.20         
         Successful Hiper Pool Reads                   0             0.00         
         Hiper Pool Read Failures                      0             0.00         
         Successful Hiper Pool Writes                  0             0.00
         Unsuccessful Hiper Pool Writes                0             0.00
         Async Pages Read                              0             0.00
         Async Pages Read by Hiper Pool                0             0.00