The MON_GET_PAGE_ACCESS_INFO table function returns information about bufferpool pages that are being waited on for a specified table. This is only applicable to DB2® pureScale® instances.
>>-MON_GET_PAGE_ACCESS_INFO--(--tabschema--,--tabname--,--member--)-><
The schema is SYSPROC.
None
This example returns page reclaim counts for all tables in schema BASETAB on the currently connected member. It shows that applications are waiting for pages for table TABLE1 (an example of what could cause this situation is updating different rows on the same page from two different members).
SELECT SUBSTR(TABNAME,1,8) AS NAME,
SUBSTR(OBJTYPE,1,5) AS TYPE,
PAGE_RECLAIMS_X AS PGRCX,
PAGE_RECLAIMS_S AS PGRCS,
SPACEMAPPAGE_PAGE_RECLAIMS_X AS SMPPGRCX,
SPACEMAPPAGE_PAGE_RECLAIMS_S AS SMPPGRCS
FROM TABLE( MON_GET_PAGE_ACCESS_INFO('BASETAB', NULL, NULL) ) AS WAITMETRICS
ORDER BY NAME;
The following is an example of output from this query.
NAME TYPE PGRCX PGRCS SMPPGRCX SMPPGRCS
-------- ----- ------ ----- -------- --------
TABLE1 TABLE 12641 320 72 17
TABLE1 INDEX 5042 78 7 0
TABLE2 TABLE 420 12 9 0
TABLE2 INDEX 7 0 0 0
The MON_GET_PAGE_ACCESS_INFO table function returns one or two rows of data for each table per member that it gathers data from. One row of data shows information for INDEX pages. The second row shows information for DATA pages. No aggregation across members is performed.