Buffer Pool Statistics Summary by Report Interval

This panel provides an overview of the buffer pool activity that was recorded during a series of report intervals.


________________ ZHBPS    VTM     O2       V550.#P DA41 11/06/13 11:41:41   2 
> Help PF1     Back PF3     Up PF7     Down PF8     Sort PF10     Zoom PF11    
> H.A.C                                                                        
>                   Enter a selection letter on the top line.                  
>                                                                              
> A-SUBSYSTEM SUPPORT      B-BIND              *-BUFFER POOL    D-GROUP BP     
> E-DISTRIBUTED DATABASE   F-EDM POOL          G-LOG MANAGER    H-OPEN/CLOSE   
> I-SQL/RID/PARALLEL/PROC  J-LOCK/CLAIM/DRAIN  K-GLOBAL LOCK    L-DB2 COMMANDS 
> O-OPTIONS                                                                    
===============================================================================
>                BUFFER POOL STATISTICS SUMMARY BY REPORT INTERVAL             
 HBPS  0                                                                       
+ Collection Interval:   1 min                           Start:  11/06 09:39   
+ Report Interval:       1 min   Combine Level:  NONE      End:  11/06 11:41   
+                                                                              
+ *                                                                            
+                 Pages   Prefetch   Prefetch   Getpages/      Pages/          
+ Interval       in Use   Requests   Failures    Sync I/O   Write I/O      DMTH
+ -----------   -------   --------   --------   ---------   ---------   -------
+ 11/06 11:41       222          0          0         .00         .00         0
+ 11/06 11:40       222          0          0         .00         .00         0
+ 11/06 11:39       222          0          0         .00         .00         0
+ 11/06 11:38       222          0          0         .00         .00         0
+ 11/06 11:37       222          0          0         .00         .00         0
+ 11/06 11:36       222          0          0         .00        1.00         0
+ 11/06 11:35       223          0          0         .00         .00         0
+ 11/06 11:34       223          0          0         .00         .00         0
+ 11/06 11:33       223          0          0         .00         .00         0
+ 11/06 11:32       223          0          0         .00         .00         0
+ 11/06 11:31       223          0          0         .00         .00         0
+ 11/06 11:30       223          0          0         .00         .00         0
+ 11/06 11:29       223          0          0         .00         .00         0
+ 11/06 11:28       223          0          0         .00         .00         0
+ 11/06 11:27       223          0          0         .00         .00         0
+ 11/06 11:26       223          0          0        6.00        1.50         0
+ 11/06 11:25       227          0          0         .00        1.63         0

Highlighting

OMEGAMONĀ® for Db2 PE highlights some fields in this panel to draw your attention to their current status:
Table 1. Highlighted fields in Buffer Pool Statistics Summary by Report Interval panel
Field Exception Reason
Pages in Use BMTH The percentage of pages in use has reached the predetermined threshold.

Navigation

For additional information about
  • another buffer pool, enter the buffer pool ID next to HBPS.
  • a report interval, move the cursor to the required line and press F11 (Zoom). (Each date/time displayed reflects the end of an interval.)
  • related topics, select one of the options at the top of the panel.
  • other topics, use the PF keys.

Fields

Collection Interval
The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.
Start
The start time of the first interval in this display.
Report Interval
This field determines the report interval. It is set on the Near-Term History Report Option panel.
Combine Level
This field reflects the selected combine level. If Combine Level is NONE, the report interval is the same as the collection interval. Possible values:
HOURLY
Data will be reported in hourly intervals.
NONE
Data will be reported in the time unit specified by the collection interval.
End
The end time of the last interval in this display.
Interval
Provides the date and time that mark the end of the report interval.
Pages in Use
A snapshot value of the current number of nonstealable buffers. A nonstealable buffer is either one which has an outstanding Getpage (that is, someone is currently looking at this page), or one which has been updated and not yet written out to DASD.
Prefetch Requests
The total number of Prefetch requests. This is the sum of Sequential, List, and Dynamic Prefetch requests.
Prefetch Failures
The number of Sequential Prefetch failures for the buffer pool during the interval. This includes failures that occurred because the SPTH threshold was reached and because the maximum number of concurrent prefetches was reached.
Getpages/Sync I/O
The ratio of Getpage requests to synchronized Read I/Os.
Pages/Write I/O
The ratio of page writes to physical I/Os.
DMTH
The number of times the Data Manager threshold was reached.