Monitor elements for viewing DB2 pureScale buffer pool activity
The IBM® DB2 pureScale Feature uses a number of monitor elements to report on buffer pool activity across a DB2 pureScale instance.
Monitor elements for the group buffer pool
The following monitor elements provide information about the group buffer (GBP) pool in the primary CF:- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- pool_async_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found by asynchronous EDUs in a local buffer pool monitor element monitor element
- pool_async_data_gbp_l_reads - Asynchronous group buffer pool data logical reads monitor element
- pool_async_data_gbp_p_reads - Asynchronous group buffer pool data physical reads monitor element
- pool_async_data_gbp_invalid_pages - Asynchronous group buffer pool invalid data pages monitor element
- pool_async_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found by asynchronous EDUs in a local buffer pool monitor element monitor element
- pool_async_index_gbp_l_reads - Asynchronous group buffer pool index logical reads monitor element
- pool_async_index_gbp_p_reads - Asynchronous group buffer pool index physical reads monitor element
- pool_async_index_gbp_invalid_pages - Asynchronous group buffer pool invalid index pages monitor element
- pool_async_xda_gbp_indep_pages_found_in_lbp - Group buffer pool independent XML storage object(XDA) pages found by asynchronous EDUs in a local buffer pool monitor element monitor element
- pool_async_xda_gbp_l_reads - Group buffer pool XDA data asynchronous logical read requests monitor element
- pool_async_xda_gbp_p_reads - Group buffer pool XDA data asynchronous physical read requests monitor element
- pool_async_xda_gbp_invalid_pages - Asynchronous group buffer pool invalid XDA data pages monitor element
Note: These monitor elements report data for the buffer pools
for each member individually;
no aggregation is performed. If you want to aggregate buffer pool
usage information for local buffer pools, such as to calculate the
average hit rates across all local buffer pools, use the SUM aggregate
function.
Refer to the reference topics
for each monitor element to see what monitoring interfaces you can
use to examine the data associated with that monitor element.Monitor elements for local buffer pools
The following monitor elements provide information about the buffer pools local to each member in the DB2 pureScale instance:- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_async_data_lbp_pages_found - Asynchronous local buffer pool data pages found monitor element
- pool_async_index_lbp_pages_found - Asynchronous local buffer pool index pages found monitor element
- pool_async_xda_lbp_pages_found - Asynchronous local buffer pool XDA data pages found monitor element
The values reported for these next
three monitor elements represent all reads from disk into the local
buffer pool for a given member:
These last three monitor elements are the same as the ones used in environments other than DB2 pureScale environments. The elements are the same, because local buffer pools for a member in a DB2 pureScale environment equivalent to the buffer pools for a database in environments other than DB2 pureScale environments.
Important:
Refer to the reference topics
for each monitor element to see what monitoring interfaces you can
use to examine the data associated with that monitor element.- The values reported by these last three monitor elements reflect reads the local buffer pools make from disk of GBP-dependent pages (that is, pages that a member requests from the GBP) that were not found in the GBP. They also include reads from disk of GBP-independent pages (that is, pages that are local to members, and for which members have no dependency on the GBP), such as temporary pages.
- Because of the relationship between LBPs and GBPs in a DB2 pureScale environment, the formulas for calculating buffer pool hit ratios are different than those used outside of a DB2 pureScale environment. See Formulas for calculating buffer pool hit ratios for more information.