Group Buffer Pool Statistics Summary by Report Interval

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

This panel is only available in a data sharing environment.


________________ ZHGBS    VTM     O2       V540.#P SN12 11/06/13 11:49:28   2 
> Help PF1     Back PF3     Up PF7     Down PF8     Sort PF10     Zoom PF11    
> H.A.D                                                                        
>                   Enter a selection letter on the top line.                  
>                                                                              
> A-SUBSYSTEM SUPPORT      B-BIND              C-BUFFER POOL    *-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                                                                    
===============================================================================
>             GROUP BUFFER POOL STATISTICS SUMMARY BY REPORT INTERVAL          
 HGBS  0                                                                       
+ Collection Interval:   1 min                           Start:  11/06 11:44   
+ Report Interval:       1 min   Combine Level:  NONE      End:  11/06 11:49   
+                                                                              
+ *                                                                            
+                                  Pages Not       Read/                       
+                 Total    Read    Returned-       Write      Total      Pages 
+ Interval        Reads   Hit %    R/W Int %      Failed     Writes    Castout 
+ -----------  --------   -----    ---------    --------   --------   -------- 
+ 11/06 11:49         0      .0           .0           0          0          0 
+ 11/06 11:48         0      .0           .0           0          0          0 
+ 11/06 11:47         0      .0           .0           0          0          0 
+ 11/06 11:46         0      .0           .0           0          0          0 
+ 11/06 11:45         5    20.0         80.0           0          5          4 
===============================================================================

Navigation

For additional information about
  • detailed statistics about a report interval, move the cursor to the line you want and press F11 (Zoom). Each date/time displayed reflects the end of an interval.
  • a different buffer pool, enter a buffer pool ID next to HGBS.
  • related topics, select one of the options from the menu.
  • 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.
Total Reads
The total number of reads to the group buffer pool.
Read Hit %
The percentage of all Reads to the group buffer pool for which the needed data was found and returned to the member.
Pages Not Returned - R/W Int %
The percentage of all Reads to the group buffer pool where
  • the data was not found in the group buffer pool and the member had to go to DASD to read the page, and
  • other members had read/write interest in the pageset, so Db2 created a directory entry for this page if it did not already exist.
Read/Write Failed
The number of Read or Write requests to the group buffer pool that failed because of a lack of storage resources.
Total Writes
The total number of writes to the group buffer pool.
Pages Castout
The number of pages that this member has castout to DASD from the group buffer pool.