-DISPLAY GROUPBUFFERPOOL command (Db2)
The Db2 command DISPLAY GROUPBUFFERPOOL displays information about the status of Db2 group buffer pools. It can also display related statistics.
Abbreviation
-DIS GBPOOL
Environment
This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program using the instrumentation facility interface (IFI).
Data sharing scope: Group
Authorization
- DISPLAY privilege
- System DBADM authority
- SYSOPR authority
- SYSCTRL authority
- SYSADM authority
Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. A logged-on z/OS user ID must be defined in RACF or a similar security server.
Syntax
Option description
- (*)
- Displays the group buffer pool status for all group buffer pools.
- ( gbpname )
- Names the group buffer pool for which status is to be displayed.
- 4-KB group buffer pools are named GBP0 through GBP49
- 8-KB group buffer pools are named GBP8K0 through GBP8K9
- 16-KB group buffer pools are named GBP16K0 through GBP16K9
- 32-KB group buffer pools are named GBP32K through GBP32K9
- ( structure-name )
- Names the backing coupling facility structure for the group buffer pool. The coupling facility structure name has the following format:
where groupname is the Db2 data sharing group name and the underscore (_) separates groupname and gbpname .groupname _ gbpname
- TYPE
- Indicates the type of group buffer pools (among those that are specified) for which information is displayed.
- (*)
- All group buffer pools are specified. This is the default.
- (GCONN)
- Group buffer pools that are currently connected to any member of the data sharing group. The connection can be
active
orfailed-persistent
. - (MCONN)
- Group buffer pools that are currently connected to the member to which the command is directed.
- (NOCACHE)
- Group buffer pools that have the GBPCACHE attribute set to NO.
- MDETAIL
- Shows a detailed statistical report for the specified group buffer pools, reflecting the member's activity for each group buffer pool. If the member to which the command is directed has never been actively connected to the group buffer pool, no detail report is shown.
- (INTERVAL)
- Shows incremental statistics. The values displayed are accumulated since the last MDETAIL(INTERVAL) report for this member, if there was one. This is the default.
- (*)
- Shows cumulative statistics. The values displayed are accumulated since this member first connected to the group buffer pool.
For more information about using the MDETAIL keyword, see Monitoring group buffer pool delete name requests.
- GDETAIL
- Shows a detailed statistical report for the specified group buffer pools, reflecting the activity of the entire group for each group buffer pool. If the member to which the command is directed is not actively connected to the group buffer pool, no detail report is shown.
- (INTERVAL)
- Shows incremental statistics. The values displayed are accumulated since the last GDETAIL(INTERVAL) report, if there was one. This is the default.
- (*)
- Shows cumulative statistics. The values displayed are accumulated since the group buffer pool was most recently allocated or reallocated.
For more information about using the GDTAIL keyword, see Monitoring storage of the group buffer pool.
- CONNLIST
- Specifies whether a connection list report is shown for the specified group buffer pools, listing the connection names of the subsystems that are currently connected to the group buffer pools and their connection status.
- (NO)
- Do not show the connection list report.
- (YES)
- Show the connection list report.
Output
Message DSNB750I indicates the beginning of the output of the command.
Usage notes
Examples
- Trace information for data sharing members
- When this command with group scope is issued in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.
- Example: Displaying a group buffer pool summary report
- Issue the following command to issue a summary report for group buffer pool GBP29:
-DISPLAY GROUPBUFFERPOOL(GBP29)
The output is similar to this output. Message DSNB799I is displayed if the group buffer pool is duplexed and the secondary group buffer pool is currently allocated. If a secondary group buffer pool is not allocated, message DSNB799I is not included in the output.
DSNB750I - DISPLAY FOR GROUP BUFFER POOL GBP29 FOLLOWS DSNB755I - DB2 GROUP BUFFER POOL STATUS CONNECTED = YES CURRENT DIRECTORY TO DATA RATIO = 5 PENDING DIRECTORY TO DATA RATIO = 5 CURRENT GBPCACHE ATTRIBUTE = YES PENDING GBPCACHE ATTRIBUTE = YES DSNB756I - CLASS CASTOUT THRESHOLD = 10,0 GROUP BUFFER POOL CASTOUT THRESHOLD = 50% GROUP BUFFER POOL CHECKPOINT INTERVAL = 8 MINUTES RECOVERY STATUS = NORMAL AUTOMATIC RECOVERY = Y DSNB757I - MVS CFRM POLICY STATUS FOR DSNCAT_GBP29 = NORMAL MAX SIZE INDICATED IN POLICY = 2048 KB DUPLEX INDICATOR IN POLICY = ENABLED CURRENT DUPLEXING MODE = DUPLEX ALLOCATED = YES DSNB758I - ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE REBUILD STATUS = DUPLEXED CFNAME = CACHE01 CFLEVEL - OPERATIONAL = 5 CFLEVEL - ACTUAL = 7 DSNB759I - NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 NUMBER OF CONNECTIONS = 2 DSNB798I - LAST GROUP BUFFER POOL CHECKPOINT 17:08:41 OCT 16, 2011 GBP CHECKPOINT RECOVERY LRSN = AF6BBAEF3307 STRUCTURE OWNER = V61B DSNB799I - SECONDARY GBP ATTRIBUTES ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE CFNAME = LF01 CFLEVEL - OPERATIONAL = 5 CFLEVEL - ACTUAL = 7 NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 DSNB790I - DISPLAY FOR GROUP BUFFER POOL GBP29 IS COMPLETE DSN9022I - DSNB1CMD '-DISPLAY GBPOOL' NORMAL COMPLETION
- Example: Displaying all connections to a group buffer pool
- The following command displays a summary report about group buffer pool 29 (GBP29), including all connections to that group buffer pool:
-DISPLAY GROUPBUFFERPOOL(GBP29) CONNLIST(YES)
The output is similar to this output:
DSNB750I - DISPLAY FOR GROUP BUFFER POOL GBP29 FOLLOWS DSNB755I - DB2 GROUP BUFFER POOL STATUS CONNECTED = YES CURRENT DIRECTORY TO DATA RATIO = 5 PENDING DIRECTORY TO DATA RATIO = 5 CURRENT GBPCACHE ATTRIBUTE = YES PENDING GBPCACHE ATTRIBUTE = YES DSNB756I - CLASS CASTOUT THRESHOLD = 10,0 GROUP BUFFER POOL CASTOUT THRESHOLD = 50% GROUP BUFFER POOL CHECKPOINT INTERVAL = 8 MINUTES RECOVERY STATUS = NORMAL AUTOMATIC RECOVERY = Y DSNB757I - MVS CFRM POLICY STATUS FOR DSNCAT_GBP29 = NORMAL MAX SIZE INDICATED IN POLICY = 2048 KB DUPLEX INDICATOR IN POLICY = ENABLED CURRENT DUPLEXING MODE = SIMPLEX ALLOCATED = YES DSNB758I - ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE REBUILD STATUS = DUPLEXED CFNAME = CACHE01 CFLEVEL - OPERATIONAL = 5 CFLEVEL - ACTUAL = 7 DSNB759I - NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 NUMBER OF CONNECTIONS = 2 DSNB798I - LAST GROUP BUFFER POOL CHECKPOINT 17:08:41 OCT 16, 2011 GBP CHECKPOINT RECOVERY LRSN = AF6BBAEF3307 STRUCTURE OWNER = V61B DSNB799I - SECONDARY GBP ATTRIBUTES ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE CFNAME = LF01 OPERATIONAL CFLEVEL = 5 ACTUAL CFLEVEL = 7 NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 DSNB766I - THE CONNLIST REPORT FOLLOWS DSNB767I - CONNECTION NAME = DB2_V61B , CONNECTION STATUS = D CONNECTOR'S RELEASE = 10100 DSNB767I - CONNECTION NAME = DB2_V61A , CONNECTION STATUS = D CONNECTOR'S RELEASE = 10100 DSNB769I - THE CONNLIST REPORT IS COMPLETE DSNB790I - DISPLAY FOR GROUP BUFFER POOL GBP29 IS COMPLETE DSN9022I - DSNB1CMD '-DISPLAY GBPOOL' NORMAL COMPLETION
- Example: Displaying a detailed report for a group buffer pool
- Issue the following command to display detailed information about group buffer pool GBP29:
-DISPLAY GROUPBUFFERPOOL(GBP29) GDETAIL(*)
The output is similar to this output. Message DSNB762I is displayed in the output only if the secondary group buffer pool is allocated.
DSNB750I - DISPLAY FOR GROUP BUFFER POOL GBP29 FOLLOWS DSNB755I - DB2 GROUP BUFFER POOL STATUS CONNECTED = YES CURRENT DIRECTORY TO DATA RATIO = 5 PENDING DIRECTORY TO DATA RATIO = 5 CURRENT GBPCACHE ATTRIBUTE = YES PENDING GBPCACHE ATTRIBUTE = YES DSNB756I - CLASS CASTOUT THRESHOLD = 10,0 GROUP BUFFER POOL CASTOUT THRESHOLD = 50% GROUP BUFFER POOL CHECKPOINT INTERVAL = 8 MINUTES RECOVERY STATUS = NORMAL AUTOMATIC RECOVERY = Y DSNB757I - MVS CFRM POLICY STATUS FOR DSNCAT_GBP29 = NORMAL MAX SIZE INDICATED IN POLICY = 2048 KB DUPLEX INDICATOR IN POLICY = ENABLED CURRENT DUPLEXING MODE = DUPLEX ALLOCATED = YES DSNB758I - ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE REBUILD STATUS = DUPLEXED CFNAME = CACHE01 CFLEVEL - OPERATIONAL = 5 CFLEVEL - ACTUAL = 7 DSNB759I - NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 NUMBER OF CONNECTIONS = 2 DSNB798I - LAST GROUP BUFFER POOL CHECKPOINT 17:08:41 OCT 16, 2011 GBP CHECKPOINT RECOVERY LRSN = AF6BBAEF3307 STRUCTURE OWNER = V61B DSNB799I - SECONDARY GBP ATTRIBUTES ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE CFNAME = LF01 OPERATIONAL CFLEVEL = 5 ACTUAL CFLEVEL = 7 NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 DSNB783I - CUMULATIVE GROUP DETAIL STATISTICS SINCE 17:08:35 OCT 16, 2011 DSNB784I - GROUP DETAIL STATISTICS READS DATA RETURNED = 4 DSNB785I - DATA NOT RETURNED DIRECTORY ENTRY EXISTED = 0 DIRECTORY ENTRY CREATED = 45 DIRECTORY ENTRY NOT CREATED = 0, 0 DSNB786I - WRITES CHANGED PAGES = 5 CLEAN PAGES = 0 FAILED DUE TO LACK OF STORAGE = 0 CHANGED PAGES SNAPSHOT VALUE = 5 DSNB787I - RECLAIMS FOR DIRECTORY ENTRIES = 0 FOR DATA ENTRIES = 0 CASTOUTS = 0 DSNB788I - CROSS INVALIDATIONS DUE TO DIRECTORY RECLAIMS = 0 DUE TO WRITES = 0 EXPLICIT = 0 DSNB762I - DUPLEXING STATISTICS FOR GBP29-SEC WRITES CHANGED PAGES = 5 FAILED DUE TO LACK OF STORAGE = 0 CHANGED PAGES SNAPSHOT VALUE = 5 DSNB790I - DISPLAY FOR GROUP BUFFER POOL GBP29 IS COMPLETE DSN9022I - DSNB1CMD '-DISPLAY GBPOOL' NORMAL COMPLETION
- Example: Displaying member detail information for a group buffer pool
- The following command displays member detail information for group buffer pool GBP29:
-DISPLAY GROUPBUFFERPOOL(GBP29) MDETAIL(*)
The output is similar to this output. Messages DSNB764I and DSNB793I are displayed in the output only if the secondary group buffer pool is allocated.
DSNB750I - DISPLAY FOR GROUP BUFFER POOL GBP29 FOLLOWS DSNB755I - DB2 GROUP BUFFER POOL STATUS CONNECTED = YES CURRENT DIRECTORY TO DATA RATIO = 5 PENDING DIRECTORY TO DATA RATIO = 5 CURRENT GBPCACHE ATTRIBUTE = YES PENDING GBPCACHE ATTRIBUTE = YES DSNB756I - CLASS CASTOUT THRESHOLD = 10,0 GROUP BUFFER POOL CASTOUT THRESHOLD = 50% GROUP BUFFER POOL CHECKPOINT INTERVAL = 8 MINUTES RECOVERY STATUS = NORMAL AUTOMATIC RECOVERY = Y DSNB757I - MVS CFRM POLICY STATUS FOR DSNCAT_GBP29 = NORMAL MAX SIZE INDICATED IN POLICY = 2048 KB DUPLEX INDICATOR IN POLICY = ENABLED CURRENT DUPLEXING MODE = DUPLEX ALLOCATED = YES DSNB758I - ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE REBUILD STATUS = DUPLEXED CFNAME = CACHE01 CFLEVEL - OPERATIONAL = 5 CFLEVEL - ACTUAL = 7 DSNB759I - NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 NUMBER OF CONNECTIONS = 2 DSNB798I - LAST GROUP BUFFER POOL CHECKPOINT 17:08:41 OCT 16, 2011 GBP CHECKPOINT RECOVERY LRSN = AF6BBAEF3307 STRUCTURE OWNER = V61B DSNB799I - SECONDARY GBP ATTRIBUTES ALLOCATED SIZE = 2048 KB VOLATILITY STATUS = VOLATILE CFNAME = LF01 OPERATIONAL CFLEVEL = 5 ACTUAL CFLEVEL = 7 NUMBER OF DIRECTORY ENTRIES = 1950 NUMBER OF DATA PAGES = 389 DSNB772I - CUMULATIVE MEMBER DETAIL STATISTICS SINCE 17:08:41 OCT 16, 2011 DSNB773I - MEMBER DETAIL STATISTICS SYNCHRONOUS READS DUE TO BUFFER INVALIDATION DATA RETURNED = 0 DATA NOT RETURNED = 0 DSNB774I - DUE TO DATA PAGE NOT IN BUFFER POOL DATA RETURNED = 0 DATA NOT RETURNED = 0 DSNB775I - PREFETCH READS DATA NOT RETURNED = 0 DSNB789I - REGISTER PAGE LIST = 0 PAGES RETRIEVED = 0 DSNB776I - SYNCHRONOUS WRITES CHANGED PAGES = 5 CLEAN PAGES = 0 DSNB777I - ASYNCHRONOUS WRITES CHANGED PAGES = 0 CLEAN PAGES = 0 FAILED WRITES DUE TO LACK OF STORAGE = 0 WRITE-AROUND PAGES = 0 DSNB778I - CASTOUT THRESHOLDS DETECTED FOR CLASSES = 0 FOR GROUP BUFFER POOL = 0 GBP CHECKPOINTS TRIGGERED = 0 PARTICIPATION IN REBUILD = 1 DSNB796I - CASTOUTS PAGES CASTOUT = 0 UNLOCK CASTOUT = 0 READ CASTOUT CLASS = 0 READ CASTOUT STATISTICS = 0 READ DIRECTORY INFO = 0 DSNB797I - OTHER INTERACTIONS REGISTER PAGE = 0 UNREGISTER PAGE = 0 DELETE NAME = 0 READ STORAGE STATISTICS = 0 EXPLICIT CROSS INVALIDATIONS = 0 ASYNCHRONOUS GBP REQUESTS = 0 DSNB764I - DUPLEXING STATISTICS FOR GBP29-SEC WRITES FAILED DUE TO LACK OF STORAGE = 0 ASYNC COMPLETION CHECKS = 0 DSNB793I - DELETE NAME LIST = 0 READ CASTOUT STATISTICS = 0 DELETE NAME = 0 OTHER ASYNCHRONOUS GBP REQUESTS = 0 DSNB790I - DISPLAY FOR GROUP BUFFER POOL GBP29 IS COMPLETE DSN9022I - DSNB1CMD '-DISPLAY GBPOOL' NORMAL COMPLETION