Buffer pools
Views for buffer pool analysis are organized into the following groups:
- Local buffer pool views (virtual pools and hiperpools)
- Global buffer pool views (group buffer pools for data sharing)
You can easily access all the views for buffer pool analysis from the DB2 Buffer Pool easy menu (EZDBFRPL) (see the following figure).
DB2 Buffer Pool Menu
Local Pools +----------------------+ Global Pools
. Overview | Place cursor on | . Group CF Status
. Activity Rates | menu item and | . Group CF Activity
| press ENTER |
Tools And Menus +----------------------+ . Read Activity
. Set Context . Write Activity
. Castout Activity
. Return... . Coupling Facility
. P-Lock Activity
The following table lists all the views available for buffer pools:
View name | Group | Type | Description |
|---|---|---|---|
BFRPL | Local Pools | Tabular | Buffer Pool Statistics–SSI Provides an overview of buffer pool activity in the current interval It can be invoked for one DB2 or in SSI mode for multiple DB2s; for example, a data sharing group to see member activity. Use this view to review total buffer allocation and usage per pool. You can select any buffer pool to see further details. |
BFRPLXD | Local Pools | Detail | Local Buffer Pool Statistics Detail Provides threshold settings and detailed local buffer pool statistics for each of these periods:
Use this view to analyze activity and threshold settings for an individual buffer pool. Both virtual pool and hiperpool information is included. |
BFRPLH | Local Pools | Tabular | Buffer Pool Rates–SSI Provides an overview of hit ratios and the most critical buffer pool activity measurements as rates per second in the current interval It can be invoked for one DB2 or in SSI mode for multiple DB2s; for example, a data sharing group to see member activity. Use this view to compare the most important indicators of buffer pool performance for all pools. |
BFRPLHD | Local Pools | Detail | Buffer Pool Rates Detail Provides the most critical measurements for the selected buffer pool as hit ratios and rates per second for each of these periods:
Use this view to determine overall activity since DB2 started and whether the current interval shows a significant deviation. |
GBPXACTD | Global Pools | Detail | Group Buffer Pool Activity Detail Provides all statistics about a single group buffer pool for one DB2 member for each of these periods:
You can use this view to see group buffer pool total activity details (reads, writes, castouts, coupling facility data) for one member and pool. |
GBPCASTM | Global Pools | Tabular | Group Buffer Pool Castout Activity Provides statistics about castout activity per pool for each DB2 member currently connected to it Use this view to analyze group buffer pool castout activity for each DB2 member. |
GBPCASTZ | Global Pools | Summary | Group Buffer Pool Castout Activity Summary Provides statistics about castout activity It is a summary of activity from each DB2 data sharing member currently connected to one or more pools. Use this view to analyze group buffer pool castout activity from the viewpoint of the DB2 members. It shows all castout-related counts. |
GBPCFM | Global Pools | Tabular | Group Buffer Pool Coupling Facility Activity Provides statistics about coupling facility activity per pool for each DB2 member that is currently connected to it Use this view to analyze group buffer pool coupling facility activity for each DB2 member. |
GBPCFZ | Global Pools | Summary | Group Buffer Pool Coupling Facility Summary Provides statistics about the coupling facility It is a summary of activity from each DB2 data sharing member currently connected to one or more pools. Use this view to analyze group buffer pool coupling facility activity from the viewpoint of the DB2 members. It shows coupling facility activity and failure counts. |
GBPGACD | Global Pools | Detail | Group Buffer Pool Group Coupling Facility Activity Detail Provides statistics about group buffer pool activity for each of these periods:
Use this view to view all available activity counts for a single group buffer pool from a global coupling facility viewpoint. |
GBPGACZ | Global Pools | Summary | Group Buffer Pool Group Coupling Facility Activity Provides statistics about group buffer pool activity Use this view to analyze the activity in all group buffer pools from a global coupling facility viewpoint. |
GBPGSTD | Global Pools | Detail | Group Buffer Pool Group Coupling Facility Status Detail Provides statistics about group buffer pool status for each of these periods:
Use this view to view the group buffer pool definitions, current usage, and a few measurements of reclaim activity from a global coupling facility viewpoint. |
GBPGSTZ | Global Pools | Summary | Group Buffer Pool Group Coupling Facility Status Provides statistics about group buffer pool status Use this view to analyze the status of all active group buffer pools from a global coupling facility viewpoint. It also shows how many DB2 members are currently connected to each pool. |
GBPLOCKM | Global Pools | Tabular | Group Buffer Pool P-Lock Activity Provides statistics about group buffer pool P-Lock activity per pool for each DB2 member currently connected to the pool Use this view to analyze group buffer pool P-Lock activity for each DB2 member. |
GBPLOCKZ | Global Pools | Summary | Group Buffer Pool P-Lock Activity Summary Provides statistics about group buffer pool P-Lock activity It is a summary of activity from each DB2 data sharing member currently connected to one or more pools. Use this view to analyze group buffer pool P-Lock activity from the viewpoint of the DB2 members. |
GBPREADM | Global Pools | Tabular | Group Buffer Pool Read Activity Provides statistics about group buffer pool read activity per pool for each DB2 member currently connected to the pool Use this view to analyze group buffer pool read activity for each DB2 member. |
GBPREADZ | Global Pools | Summary | Group Buffer Pool Read Activity Summary Provides statistics about group buffer pool read activity It is a summary of activity from each DB2 data sharing member currently connected to one or more pools. Use this view to analyze group buffer pool read activity from the viewpoint of the DB2 members. It shows synchronous and asynchronous reads caused either by buffer invalidation or because the pages were not in the local pool. |
GBPWRITM | Global Pools | Tabular | Group Buffer Pool Write Activity Provides statistics about group buffer pool write activity per pool for each DB2 member currently connected to the pool Use this view to analyze group buffer pool write activity for each DB2 member. |
GBPWRITZ | Global Pools | Summary | Group Buffer Pool Write Activity Summary Provides statistics about group buffer pool write activity It is a summary of activity from each DB2 data sharing member currently connected to one or more pools. Use this view to analyze group buffer pool write activity from the viewpoint of the DB2 members. It shows synchronous and asynchronous writes for changed and clean pages as well as failures due to a lack of storage or write engines. |
Related topic