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 0Highlighting
OMEGAMON® for Db2
PE highlights some fields in this panel to draw your attention to their current status:
| 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.