Group buffer pool monitoring with the DISPLAY GROUPBUFFERPOOL command

You can use the DISPLAY GROUPBUFFERPOOL command to display information about group buffer pools.

Procedure

Begin general-use programming interface information.

Issue the DISPLAY GROUPBUFFERPOOL command.

For example, assuming that you want a summary report about group buffer pool zero (GBP0), including all connections to that group buffer pool, you might issue the following command:

-DB1A DISPLAY GROUPBUFFERPOOL(GBP0) CONNLIST(YES)

The following outptut shows what the display might look like, assuming that the group buffer pool is duplexed.

DSNB750I -DB1A DISPLAY FOR GROUP BUFFER POOL GBP0 FOLLOWS
DSNB755I -DB1A DB2 GROUP BUFFER POOL STATUS
                 CONNECTED                                  = YES
                 CURRENT DIRECTORY TO DATA RATIO            = 5.4
                 PENDING DIRECTORY TO DATA RATIO            = 6.0
                 CURRENT GBPCACHE ATTRIBUTE                 = YES
                 PENDING GBPCACHE ATTRIBUTE                 = YES
DSNB756I -DB1A   CLASS CASTOUT THRESHOLD                    = 5,0
                 GROUP BUFFER POOL CASTOUT THRESHOLD        = 30%
                 GROUP BUFFER POOL CHECKPOINT INTERVAL      = 4 MINUTES
                 RECOVERY STATUS                            = NORMAL
                 AUTOMATIC RECOVERY                         = Y
DSNB757I -DB1A MVS CFRM POLICY STATUS FOR DSNDB0A_GBPO      = NORMAL
                 MAX SIZE INDICATED IN MVS POLICY           = 61440 KB
                 DUPLEX INDICATOR IN POLICY                 = ENABLED
                 CURRENT DUPLEXING MODE                     = DUPLEX
                 ALLOCATED                                  = YES
DSNB758I -DB1A   ALLOCATED SIZE                             = 61440 KB
                 VOLATILITY STATUS                          = NON-VOLATILE
                 REBUILD STATUS                             = DUPLEXED
                 CFNAME                                     = LF01
                 OPERATIONAL CFLEVEL                        = 5
                 ACTUAL CFLEVEL                             = 7
DSNB759I -DB1A   NUMBER OF DIRECTORY ENTRIES                = 61394
                 NUMBER OF DATA PAGES                       = 11370
                 NUMBER OF CONNECTIONS                      = 3
DSNB798I -DB1A LAST GROUP BUFFER POOL CHECKPOINT 17:31:23 MAY  9, 2002
                 GBP CHECKPOINT RECOVERY LRSN               = ACD74C77388C
                 STRUCTURE OWNER                            = DB1A
DSNB799I  -DB1A SECONDARY GBP IS ALLOCATED
                 ALLOCATED SIZE                             = 61440 KB
                 VOLATILITY STATUS                          = NON-VOLATILE
                 CFNAME                                     = LF01
                 OPERATIONAL CFLEVEL                        = 5
                 ACTUAL CFLEVEL                             = 7
                 NUMBER OF DIRECTORY ENTRIES                = 61394
                 NUMBER OF DATA PAGES                       = 11370
DSNB766I -DB1A THE CONNLIST REPORT FOLLOWS
DSNB767I -DB1A CONNECTION NAME = DB2_DB1A     , CONNECTION STATUS = A
                   CONNECTOR'S RELEASE                    =     10100
DSNB767I -DB1A CONNECTION NAME = DB2_DB2A     , CONNECTION STATUS = A
                   CONNECTOR'S RELEASE                    =     10100
DSNB767I -DB1A CONNECTION NAME = DB2_DB3A     , CONNECTION STATUS = F
                   CONNECTOR'S RELEASE                    =     10100
DSNB769I -DB1A THE CONNLIST REPORT IS COMPLETE
DSNB790I -DB1A DISPLAY FOR GROUP BUFFER POOL GBP0 IS COMPLETE
DSN9022I -DB1A DSNB1CMD 'DISPLAY GROUPBUFFERPOOL' NORMAL COMPLETION

End general-use programming interface information.

What to do next

For an easy way to collect interval statistics for performance analysis, create a batch job that issues the following command periodically:

-DB1A DISPLAY GROUPBUFFERPOOL(*) GDETAIL(INTERVAL)

The first time you run the batch job is the base which purges existing statistics and resets the interval. If you run the job the second time 5 minutes after the first, you can continue running the job every 5 minutes to gather meaningful statistical data on group buffer pool activity.

You can also display more detailed statistics by specifying the GDTAIL and MDETAIL keywords in the GROUP BUFFERPOOL command:

For more information about using the GDETAIL keyword, see Monitoring storage of the group buffer pool.
For more information about using the MDETAIL keyword, see Monitoring group buffer pool delete name requests.