Obtaining information about group buffer pools

Db2 provides a DISPLAY GROUPBUFFERPOOL command that is useful for displaying statistical information about group buffer pool use.

However, you can also obtain information about group buffer pools by using the z/OS® command D XCF,STR.

Depending on the options you choose for the command, the display output contains the following information:
  • A list of all connections to the group buffer pools. For duplexed group buffer pools, only one set of connections exists for both instances of the group buffer pool. For example, if there are three connections to duplexed structure GBP0, there are just three connections, not six connections.
  • Statistical reports on group buffer pool use, either by a specific member or by the whole group. Some statistical information is also available for the secondary allocation of a duplexed group buffer pool.