Viewing buffer pool statistics for an exception
Follow these steps to view buffer pool statistics for an exception.
Procedure
- On the DB2 Query Monitor main menu, type 5 in the Option field and press Enter.
- Locate the exception for which you want to view buffer pool statistics.
-
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