Purescale performance shows PureScale performance metrics and cache facility state.

This view is populated only if the monitored database is pureScale. For non pureScale databases, dmctop opens a pop-up with the message “Available only for pureScale”.

Identifier for the database member.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).MEMBER

The number of lock waits due to the application holding the lock being on a remote member.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(LOCK_WAITS_GLOBAL)

The percentage of time spent on global lock waits over the time spent on requests.

= LOCK_WAIT_TIME_GLOBAL / TOTAL_RQST_TIME

Source:

LOCK_WAIT_TIME_GLOBAL = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(LOCK_WAIT_TIME_GLOBAL)

TOTAL_RQST_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_RQST_TIME)

The number of lock timeouts.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(LOCK_TIMEOUTS_GLOBAL)

The number of lock escalations on a global lock.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(LOCK_ESCALS_GLOBAL)

The number of times that the database system waited while it communicated with a cluster caching facility.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(CF_WAITS)

The percentage of time spent on communicating with the cluster caching facility over the time spent on requests.

= CF_WAIT_TIME / TOTAL_RQST_TIME

Source:

CF_WAIT_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(CF_WAIT_TIME)

TOTAL_RQST_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_RQST_TIME)

The average time spent on communicating with the cluster caching facility.

= CF_WAIT_TIME / CF_WAITS

Source:

CF_WAIT_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(CF_WAIT_TIME)

CF_WAITS = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(CF_WAITS)

The number of times a page related to the object was reclaimed by another member in the Db2® pureScale® instance before its planned release, where the member that reclaimed the page required exclusive access.

Source: MON_GET_PAGE_ACCESS_INFO(NULL, NULL, #MEMBER#).SUM(PAGE_RECLAIMS_X)

The number of times a page related to the object was reclaimed by another member in the Db2 pureScale instance before its planned release, where the member that reclaimed the page required shared access.

Source: MON_GET_PAGE_ACCESS_INFO(NULL, NULL, #MEMBER#).SUM(PAGE_RECLAIMS_S)

The percentage of time spent on waiting on page locks, where the lock request caused a page to be reclaimed, over the time spent on requests.

= RECLAIM_WAIT_TIME / TOTAL_RQST_TIME

Source:

RECLAIM_WAIT_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(RECLAIM_WAIT_TIME)

TOTAL_RQST_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_RQST_TIME)