Group Buffer Pool Status
The Group Buffer Pool Status report provides a high-level overview of the status of the group buffer pools associated with the selected Db2 subsystem.
Command ====> _______________________________________________ Scroll ===> CSR_
BMCSftwr.PMDGBPS -- GROUP BUFFER POOL STATUS -- 06/19 15:42:22
---< HELP >--------------------< *ALERT* >----------------------< CONFIG >---
Actions: ( + ) A - ADVICE S - Global GBP Statistics H - History
( + ) P - Page Sets with IDRW
Data Sharing Group: DSNDHY Interval Start: 15:31:01
Member Name : DHY1 Duration : 00:11:22
Page XIRds NFRds PgWrt WrFail XIDir
GBP ID Eff sets /Sec /Sec /Sec /Sec Rclm/Sec TRdHR XRdHR Rd/Wrt C/O
------- ---- ----- ----- ----- ----- ------ -------- ----- ----- ------ ----
+ GP0 46% 248 0 0 0 0 72 52 80 3.91 0
+ GP25 26% 4794 0 0 0 0 1 17 30 0.08 1
+ GP49 1% 288 1 1 6 0 9 0 0 0.00 101
+ GP8K0 100% 12 0 0 0 0 0 100 100 0.00 0
Data sharing can greatly enhance the performance, flexibility, and availability of any high volume data management and processing system. However, whenever data is shared, data integrity is extremely important and must be assured at all times. Db2 uses group buffer pools and special locking mechanisms to ensure data integrity when different Db2 subsystems share data.
The Group Buffer Pool Details report provides information about the operational status and Db2 group buffer pools configuration that members of a data sharing group share in a parallel sysplex environment.
Use the S action code to display the Group Buffer Pool Details report, which shows statistics associated with the group buffer pool.
Command ====> _______________________________________________ Scroll ===> CSR_
More: +
BMCSftwr.PMDGBPT -- GROUP BUFFER POOL DETAILS -- 06/19 15:42:52
---< HELP >--------------------< *ALERT* >----------------------< CONFIG >---
Actions: ( + ) S - Efficiency Calculation Details D - GBP Details
DS GROUP: DSNDHY INTERVAL BEGIN: 15:31:01
GBPOOL : GBP25 DURATION : 00:11:52
GBPOOL SIZE: 512 PAGES GBPCACHE: Y
DIR ENTRIES: 816 IN USE : 55
DATA PAGES : 163 IN USE : 17 CHANGED: 17
PAGE READ REQS : 21.01 /SEC FAILURES: 0.00 % (IN DIR CREATE)
PG RD HITRATIO : 0.25 % READ/WRT: 0.00
PAGE WRITES : 19.11 /SEC FAILURES: 0.00 %
PAGE WRT RE-UPDTS : 0.52 /SEC RATIO : 0.03 %
DIR RECLAIMS W/XI : 0.89 /SEC
DIR RECLAIMS-TOTAL: 0.97 /SEC MIN DIR RESIDENCY : 844 SECONDS
DATA PG RECLAIMS : 18.13 /SEC MIN PAGE RESIDENCY: 9 SECONDS
CASTOUT PAGE RATE : 0.01 /SEC
CLASS CASTOUTS : 0 CLASS CASTOUT THR : 10 %
GROUP CASTOUTS : 1 GROUP CASTOUT THR : 10 %
CHECKPOINTS : 10 CHKPOINT INTERVAL : 1 MINUTES
Db2 EFF XIREADS NFREADS PGWRTS WRFAILS TRDHR XRDHR RD/WRT C/OS CKPTS
---- ----- ------- ------- ------ ------- ----- ----- ------ ---- -----
+ DHY1 26 % 30 24 106 0 17 30 0.08 1 9
+ DHY2 32 % 5 27 27 0 13 60 0.15 0 1
The statistics reported relate to the entire group buffer pool. The values are identical, regardless of the Db2 subsystem selected from the Buffer Pools Status Monitor report (see Buffer-Pools-Status-Monitor).
Statistics for each Db2 subsystem in the data sharing group are listed at the bottom of the report. Use the S action code to expand the report (as displayed in Expand for Efficiency Calculation Details) to show more detailed statistics for each Db2 subsystem.
---- ----- ------- ------- ------ ------- ----- ----- ------ ---- -----
+ DHY1 26 % 30 24 106 0 17 30 0.08 1 9
---------------------------------------------------------------------
Efficiency calculation detail: Highest possible efficiency 100
LOCAL: IF PAGE WRITES>0 (SW+WC+AW+AC = 106 )
IF WRT FAIL>0 subtract 2 - 0
subtract WRT FAIL% (WF/(SW+WC+AW+AC)) - 0
subtract 1/10 XI READ MISS RATIO - 7
subtract 1/100 CHG PG WRTS/RD - 0
IF CLEAN PAGE WRITES>0 ( WC+AC = 36 )
subtract 1/10 MISSING PAGE READ MISS RATIO - 10
subtract 1/100 CLN PG WRTS/RD - 0
GLOBAL: subtract WRITE FAIL RATIO (WF/(WH+WC)) - 0
subtract DIR CREATE FAIL RATIO (RF/(RH+RD+RN+RF)) - 0
IF DIR RECLAIM XIS > 0 subtract 2 - 2
subtract % DIR RECLAIMS CAUSING XI - 50
CURRENT CALCULATED EFFICIENCY: 30
---------------------------------------------------------------------
NOTE: Full detail data list available via "D" action code
---------------------------------------------------------------------
+ DHY2 32 % 5 29 29 0 12 60 0.14 0 1
Related topic