The MON_GET_WORK_ACTION_SET_STATS function returns the statistics for a work action set.
None
>>-MON_GET_WORK_ACTION_SET_STATS--(--work_action_set_name--,----> >--member--)---------------------------------------------------><
The schema is SYSPROC.
Column name | Data type | Description |
---|---|---|
WORK_ACTION_SET_NAME | VARCHAR(128) | work_action_set_name - Work action set name monitor element |
DBPARTITIONNUM | SMALLINT | dbpartitionnum - Database partition number monitor element |
LAST_RESET | TIMESTAMP | last_reset - Last Reset Timestamp monitor element |
WORK_CLASS_NAME | VARCHAR(128) | work_class_name - Work class name monitor element |
ACT_TOTAL | BIGINT | act_total - Activities total monitor element |
MEMBER | SMALLINT | member - Database member monitor element |
SELECT SUBSTR(WORK_ACTION_SET_NAME,1,18) AS WORK_ACTION_SET_NAME,
SUBSTR(CHAR(MEMBER),1,4) AS MEMB,
SUBSTR(WORK_CLASS_NAME,1,15) AS WORK_CLASS_NAME,
LAST_RESET,
SUBSTR(CHAR(ACT_TOTAL),1,14) AS ACT_TOTAL
FROM TABLE(MON_GET_WORK_ACTION_SET_STATS
(CAST(NULL AS VARCHAR(128)), -2)) AS WASSTATS
ORDER BY WORK_ACTION_SET_NAME, WORK_CLASS_NAME, MEMB
WORK_ACTION_SET_NAME MEMB WORK_CLASS_NAME LAST_RESET ACT_TOTAL
-------------------- ---- --------------- -------------------------- --------------
AdminActionSet 0 ReadClass 2005-11-25-18.52.49.343000 8
AdminActionSet 1 ReadClass 2005-11-25-18.52.50.478000 0
AdminActionSet 0 LoadClass 2005-11-25-18.52.49.343000 2
AdminActionSet 1 LoadClass 2005-11-25-18.52.50.478000 0
AdminActionSet 0 * 2005-11-25-18.52.49.343000 7
AdminActionSet 1 * 2005-11-25-18.52.50.478000 0