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 87.79 Get Page Requests 258,555 258,555.24 Buffer Pages Updated 0 0.00 Synchronous Pages Read 29,922 29,922.00 Synchronous Pages Written 0 0.00 Sequential Prefetch Requests 1 1.00 List Prefetch Requests 20 20.00 Dynamic Prefetch Requests 95 95.20 Async Pages Read 1,642 1,642.00 zHyperlink Cache Hits 29,922 29,922.00 zHyperlink READ I/O 0 0.00 zHyperlink Read Elapse Time 0 ***************************** Bottom of Data **********************************