Group Buffer Pool Status
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
BMCSftwr.PMDGBPS -- GROUP BUFFER POOL STATUS -- 06/02 05:12:22
---< HELP >--------------------< *ALERT* >----------------------< CONFIG >---
ACTIONS: ( + ) A - ADVICE S - GLOBAL GBP STATISTICS H - HISTORY
( + ) P - PAGE SETS WITH IDRW C - COUPLING FACILITY AND STRUCTURE
DATA SHARING GROUP: DSNDLY INTERVAL START: 05:00:03
MEMBER NAME : DLY7 DURATION : 00:12:19
PAGE XIRDS NFRDS PGWRT WRFAIL XIDIR
GBP ID EFF SETS /SEC /SEC /SEC /SEC RCLM/SEC TRDHR XRDHR RD/WRT C/O
------- ---- ----- ----- ----- ----- ------ -------- ----- ----- ------ ----
+ GP0 38% 14897 0 0 0 0 2 0 0 0.00 0
+ GP8K0 100% 6926 0 0 0 0 0 0 0 0.00 0
+ GP16K0 100% 202 0 0 0 0 0 0 0 0.00 0
+ GP32K 100% 201 0 0 0 0 0 0 0 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 relate to the entire group buffer pool. The values are identical, regardless of the Db2 subsystem selected from the Buffer Pools Status Monitor report. For more information, 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 view 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
(BMC.DB2.SPE2307)Use the C action code to display the GBP CF Structure Info report, which displays Coupling Facility Cache Structure details associated with the group buffer pool. This report provides statistical details for the Cache Structures.
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
BMCSftwr.PMDGCFS -- GBP CF STRUCTURE INFO -- 06/02 05:25:51
---< HELP >--------------------< *ALERT* >----------------------< CONFIG >---
ACTIONS: ( + ) D - DETAILS
( + )
DATA SHARING GROUP: DSNDLY INTERVAL START: 05:15:02
MEMBER NAME : DLY7 DURATION : 00:10:47
STR ALC MAX MIN % SZ ENTRY ENTRY ENTRY ELMT ELMT ELMT # SYNC
NAME SZ SZ SZ USED TOT USE CHGD TOT USE CHGD TO ASYNC
---------------- --- --- --- ----- -------- -------- -------- -------- -------- -------- --------
+ DSNDLY_GBP8K0 15 15 0 100% 5279 1 0 1055 0 0 0
Use the D action to display the GBP CF DETAILED INFORMATION report, which displays Coupling Facility Detailed Information associated with the Coupling Facility Cache Structure. This report provides additional information about the Coupling Facility Cache Structure.
COMMAND ====> _______________________________________________ SCROLL ===> CSR_
MORE: +
BMCSftwr.PMDGCFD -- GBP CF DETAILED INFORMATION -- 06/02 05:26:57
---< HELP >--------------------< *ALERT* >----------------------< CONFIG >---
DS GROUP: DSNDLY INTERVAL BEGIN: 05:15:02
GBPOOL : GBP8K0 DURATION : 00:11:55
STR NAME: DSNDLY_GBP8K0
*DETAILS FOR ACTIVE CF:-
CF NAME : CF12
CF STATUS : ACTIVE
NO SUBCHANNEL : 0
NODE DETAILS : 003931.IBM.02.00000007A498 PARTITION:0E CPCID:00
PHYSICAL VERSION : DD5BA098 B87C9140
LOGICAL VERSION : DD5BA098 B87C9140
MAX CONNECTION : 100
*ADDITIONAL DETAILS:-
EVENT MANAGEMENT : Y
DUPLEX ENABLED : N
ALLOW AUTO ALTER : N
ALLOW REALLOCATE : Y
ENFORCE ORDER : N
ENCRYPTION LEVEL : N
FULL THRESHOLD : 80
REBUILD PERCENT : 0
PREFERENCE LIST : CF12
EXCLUSION LIST : LIST IS EMPTY
# OF CONNECTIONS : 10