Displaying buffer pool hit ratios

A buffer pool hit ratio is calculated as the number of hits in the buffer pool divided by the number of GETPAGES.

Procedure

To display buffer pool hit ratios:

On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
The System Administration (ADB2Z) panel is displayed.

Specify option BH, and press Enter.

The Display Buffer Pool Hit Ratios (ADB2ZBH) panel is displayed, as shown in the following figure.

Figure 1. Display Buffer Pool Hit Ratios (ADB2ZBH) panel

 DB2 Admin -------------- DB2X Display Buffer Pool Hit Ratios ------------ 23:45
 Command ===>                                                                   
                                                                                
  -DISPLAY BUFFERPOOL(                                                          
   Buffer pool name    ===>          (Active, BP0-49, BP8K_, BP16K_, BP32K_, *) 
 ) DETAIL(                                                                      
   Include details     ===>          (Interval or *)                            
 )

Enter the name of a buffer pool.
The following values are valid:

Active

All active buffer pools.

BP0–BP49, BP8K_, BP16K_, BP32K_

Select a specific buffer pool name from the valid values available.

*

All buffer pools.
Specify the interval for which information should be displayed; the interval can be either since the buffer pool was created (*) or since the last display (interval).

Press Enter.

Db2® Admin Tool issues the Db2 DISPLAY BUFFERPOOL command to generate the Buffer Pool Hit Ratios (ADB2ZBH2) panel, as shown in the following figure.

Figure 2. Buffer Pool Hit Ratios (ADB2ZBH2) panel

 DB2 Admin ------------- DB2X Buffer Pool Hit Ratios --------------------------- 
 Command ===>                                                                    
                                                                                 
 Line commands:                                                               
 DIS  - Display incremental statistics  DISC - Display cumulative statistics 
 A - Auth  RE - Revoke  GR - Grant                                           
 ? - Show all line commands                                                  
                                                                       
                                                                                 
        BP                         Random     Random    Hit                      
 Select Name   VP Size  HP Size Get Pages      I/Os   Ratio                      
 ------ ------ -------- ------- --------- ---------- ------                      
        BP0                         63605       1262  98.02                      
        BP1                           256         14  94.53                      
        BP2                           568         99  82.57                      
        BP3                           519         12  97.69                      
        BP32K                        1152          0 100.00                      
        BP8K0                       38772       2134  94.50                      
        BP16K0                        556         12  97.84                      
******************************* END OF DB2 DATA *******************************