Group Buffer Pool Activity
This topic shows detailed information about Accounting - Group Buffer Pool Activity
.
This block is printed for each active group buffer pool. When there is more than one active group buffer pool, a totals block is printed for each aggregation.
The following example shows both layouts, the report on the left, and the trace layout on the right.
Accounting - Group Buffer Pool Activity
The field labels shown in the following sample layout of Accounting - Group Buffer Pool Activity
are described in the following section.
Report: Trace:
GROUP BP1 AVERAGE GROUP BP0 TOTAL
---------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 0.00 GBP-DEPEND GETPAGES 0
READ(XI)-DATA RETUR 0.00 READ(XI)-DATA RETUR 0
READ(XI)-NO DATA RT 0.00 READ(XI)-NO DATA RT 0
READ(NF)-DATA RETUR 0.00 READ(NF)-DATA RETUR 0
READ(NF)-NO DATA RT 0.00 READ(NF)-NO DATA RT 0
PREFETCH PAGES READ 0.00 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0.00 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 0.00 UNREGISTER PAGE 0
ASYNCH GBP REQUESTS 0.00 ASYNCH GBP REQUESTS 0
EXPLICIT X-INVALID 0.00 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0.00 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 0.00 PG P-LOCK LOCK REQ 0
SPACE MAP PAGES 0.00 SPACE MAP PAGES 0
DATA PAGES 0.00 DATA PAGES 0
INDEX LEAF PAGES 0.00 INDEX LEAF PAGES 0
PG P-LOCK UNLOCK REQ 0.00 PG P-LOCK UNLOCK REQ 0
PG P-LOCK LOCK SUSP 0.00 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0.00 SPACE MAP PAGES 0
DATA PAGES 0.00 DATA PAGES 0
INDEX LEAF PAGES 0.00 INDEX LEAF PAGES 0
WRITE AND REGISTER 0.00 WRITE AND REGISTER 0
WRITE & REGISTER MULT 0.00 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 0.00 CHANGED PAGES WRITTEN 0
COMPL CHECKS SUSPEND 0.00 COMPL CHECKS SUSPEND 0
- GBP-DEPEND GETPAGES
-
The number of coupling facility READ requests required because the buffer was marked invalid. Data is returned from the group buffer pool.
Field Name: QBGAGG
- READ(XI)-DATA RETUR
-
The number of coupling facility read requests required because the buffer was marked invalid. Data is returned from the group buffer pool.
Field Name: QBGAXD
- READ(XI)-NO DATA RT
-
The number of synchronous coupling facility read requests necessary because the buffer was marked invalid. Data is not returned from the group buffer pool.
Field Name: ABGAXR
This is an exception field.
- READ(NF)-DATA RETUR
-
The number of coupling facility read requests necessary because the requested page was not found in the buffer pool. Data is returned from the coupling facility.
Field Name: QBGAMD
This is an exception field.
- READ(NF)-NO DATA RT
-
The number of synchronous coupling facility read requests necessary because the requested page was not found in the buffer pool. Data is not returned from the coupling facility.
Field Name: ABGAMR
This is an exception field.
- PREFETCH PAGES READ
-
The number of pages read from the group buffer pool due to prefetch under the control of the agent.
Field Name: QBGAMN
This is an exception field.
- CLEAN PAGES WRITTEN
-
The number of clean pages written to the group buffer pool.
Field Name: QBGAWC
This is an exception field.
- UNREGISTER PAGE
-
The number of coupling facility requests to unregister a page.
Field Name: QBGADG
This is an exception field.
- ASYNCH GBP REQUESTS
-
The number of asynchronous IXLCACHE invocations for the primary group buffer pool.
Field Name: QBGAHS
- EXPLICIT X-INVALID
-
The number of times an explicit coupling facility cross-invalidation request was issued.
Field Name: QBGAEX
- ASYNCH SEC-GBP REQ
-
The number of IXLCACHE invocations for the secondary group buffer pool.
Field Name: QBGA2H
- PG P-LOCK LOCK REQ
-
The number of all page P-lock lock requests.
Field Name: ABGAPLR
- SPACE MAP PAGES
-
The number of page P-lock lock requests for space map pages.
Field Name: QBGAP1
- DATA PAGES
-
The number of page P-lock lock requests for data pages.
Field Name: QBGAP2
- INDEX LEAF PAGES
-
The number of page P-lock lock requests for index-leaf pages.
Field Name: QBGAP3
- PG P-LOCK UNLOCK REQ
-
The number of page P-lock unlock requests.
Field Name: QBGAU1
- PG P-LOCK LOCK SUSP
-
The sum of all page P-lock lock suspensions.
Field Name: ABGAPLS
- SPACE MAP PAGES
-
The number of page P-lock suspensions for space-map pages.
Field Name: QBGAS1
- DATA PAGES
-
The number of page P-lock lock suspensions for data pages.
Field Name: QBGAS2
This is an exception field.
- INDEX LEAF PAGES
-
The number of page P-lock lock suspensions for index-leaf pages.
Field Name: QBGAS3
- WRITE AND REGISTER
-
The number of Write and Register (WAR) requests.
Field Name: QBGAWS
- WRITE & REGISTER MULT
-
The number of write and register multiple (warm) requests.
Field Name: QBGAWM
- CHANGED PAGES WRITTEN
-
The number of changed pages written to the group buffer pool as a result of write and register (WAR), or write and register multiple (WARM) requests.
Field Name: QBGASW
This is an exception field.
- WRITE TO SEC-GBP
-
The number of requests to write changed pages to the secondary GBP for duplexing.
Field Name: QBGA2W
- COMPL CHECKS SUSPEND
-
The number of completion checks for writes to the secondary GBP that were suspended because the write had not yet been completed.
Field Name: QBGA2S