Skew monitor view presents data useful in assessing skew in access patterns. When a query accesses more data on some members than on others, the more heavily loaded members become bottlenecks, making the whole query take longer.

The numeric identifier for the database member from which the data was retrieved for this result record.

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

The total amount of CPU time used while within the database system.

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

Indicates the number of data, index, and column-organized pages which have been requested from the buffer pool (logical) for regular, large and temporary table spaces.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).(SUM(POOL_DATA_L_READS) + SUM(POOL_INDEX_L_READS) + SUM(POOL_XDA_L_READS) + SUM(POOL_COL_L_READS) + SUM(POOL_TEMP_DATA_L_READS) + SUM(POOL_TEMP_INDEX_L_READS) + SUM(POOL_TEMP_XDA_L_READS) + SUM(POOL_TEMP_COL_L_READS))

Indicates the number of data, index, and column-organized pages which have been requested from the buffer pool (logical) for temporary table spaces.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).(SUM(POOL_TEMP_DATA_L_READS) + SUM(POOL_TEMP_INDEX_L_READS) + SUM(POOL_TEMP_XDA_L_READS) + SUM(POOL_TEMP_COL_L_READS))

The number of rows read from the table.

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

The number of rows inserted, updated, or deleted.

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

The total number of buffers received from table queues using the internal FCM communications mechanism.

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

The total number of buffers containing table queue data sent using the internal FCM communications mechanism.

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

Total number of table queue buffers overflowed to a temporary table.

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

The number of times that operations exceeded the available sort heap memory.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).(SUM(SORT_OVERFLOWS) + SUM(HASH_JOIN_OVERFLOWS) + SUM(OLAP_FUNC_OVERFLOWS) + SUM(HASH_GRPBY_OVERFLOWS))

The total amount of data received and distributed via the FCM communications layer.

Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(FCM_RECV_VOLUME + FCM_SEND_VOLUME)

The total number of buffers sent using the internal FCM communications layer.

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

The total number of buffers received for internal requests using the FCM communications mechanism.

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

The total number of coordinator activities at any nesting level that completed successfully.

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

The total number of requests executed, including both application and internal requests.

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

The activities that were submitted by the application on the specified member and have not yet been completed.

WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES(NULL, #MEMBER#)