WLM monitoring through event monitors

[Luiz da Silva]

Regarding this comment about WLM monitoring on Info Center(https://www-01.ibm.com/support/knowledgecenter/#!/SSEPGG_9.7.0/com.ibm.db2.luw.admin.wlm.doc/doc/c0052603.html):

"You can collect information about an activity by specifying COLLECT ACTIVITY DATA for the service class, workload, or work action to which such an activity belongs or a threshold that might be violated by such an activity. The information is collected when the activity completes, regardless of whether the activity completes successfully."

I have created my WLM event monitors like this:

CREATE EVENT MONITOR DB2ACTIVITIES
FOR ACTIVITIES
WRITE TO TABLE
ACTIVITY (TABLE ACTIVITY_DB2ACTIVITIES
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
ACTIVITYSTMT (TABLE ACTIVITYSTMT_DB2ACTIVITIES
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
ACTIVITYVALS (TABLE ACTIVITYVALS_DB2ACTIVITIES
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
ACTIVITYMETRICS (TABLE ACTIVITYMETRICS_DB2ACTIVITIES
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
CONTROL (TABLE CONTROL_DB2ACTIVITIES
IN WLM_16K_TBSP
PCTDEACTIVATE 100)
AUTOSTART;


CREATE EVENT MONITOR DB2STATISTICS
FOR STATISTICS
WRITE TO TABLE
SCSTATS (TABLE SCSTATS_DB2STATISTICS
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
WCSTATS (TABLE WCSTATS_DB2STATISTICS
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
WLSTATS (TABLE WLSTATS_DB2STATISTICS
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
QSTATS (TABLE QSTATS_DB2STATISTICS
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
HISTOGRAMBIN (TABLE HISTOGRAMBIN_DB2STATISTICS
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
CONTROL (TABLE CONTROL_DB2STATISTICS
IN WLM_16K_TBSP
PCTDEACTIVATE 100)
AUTOSTART;


CREATE EVENT MONITOR DB2THRESHOLDVIOLATIONS
FOR THRESHOLD VIOLATIONS
WRITE TO TABLE
THRESHOLDVIOLATIONS (TABLE THRESHOLDVIOLATIONS_DB2THRESHOLDVIOLATIONS
IN WLM_16K_TBSP
PCTDEACTIVATE 100),
CONTROL (TABLE CONTROL_DB2THRESHOLDVIOLATIONS
IN WLM_16K_TBSP
PCTDEACTIVATE 100)
AUTOSTART;

I have alter my Workloads and Service Classes to collect activity info:

alter workload xyz_wl COLLECT ACTIVITY DATA ON ALL DATABASE PARTITIONS WITH DETAILS AND VALUES ;

ALTER SERVICE CLASS long_running_sc UNDER online_sc COLLECT ACTIVITY DATA ON ALL DATABASE PARTITIONS WITH DETAILS AND VALUES

I see ACTIVITYSTMT_DB2ACTIVITIES being filled, which is a good start, but I don't action in the other event monitor target tables:


Counting...

----------------------
ACTIVITY_DB2ACTIVITIES
884926
----------------------
ACTIVITYMETRICS_DB2ACTIVITIES
0
----------------------
ACTIVITYSTMT_DB2ACTIVITIES
881760
----------------------
ACTIVITYVALS_DB2ACTIVITIES
1283311
----------------------
CONTROL_DB2ACTIVITIES
8
----------------------
CONTROL_DB2STATISTICS
8
----------------------
CONTROL_DB2THRESHOLDVIOLATIONS
8
----------------------
HISTOGRAMBIN_DB2STATISTICS
0
----------------------
QSTATS_DB2STATISTICS
0
----------------------
SCSTATS_DB2STATISTICS
0
----------------------
THRESHOLDVIOLATIONS_DB2THRESHOLDVIOLATIONS
0
----------------------
WCSTATS_DB2STATISTICS
0
----------------------
WLSTATS_DB2STATISTICS
0

I'm digging in the WLM documentation, but I don't see a clear documentation showing the correlation between the event monitor target tables and the entities/objects in WLM that need to be updated? Something like update/alter here, then see the corresponding monitoring info there...

Thanks,
~Luiz