DB2 10.5 for Linux, UNIX, and Windows

WLM_COLLECT_STATS procedure - Collect and reset workload management statistics

The WLM_COLLECT_STATS procedure gathers statistics for service classes, workloads, work classes, and threshold queues and writes them to the statistics event monitor.

This procedure also resets the statistics for service classes, workloads, work classes, and threshold queues.

If there is no active statistics event monitor, the procedure only resets the statistics.

The functionality of WLM_COLLECT_STATS is identical to the functionality of MON_COLLECT_STATS. Although the functionality for these two routines is the same, the authorization is not necessarily the same. See MON_COLLECT_STATS for syntax, parameters, usage notes, and examples.

Authorization

One of the following authorities is required to execute the routine:

EXECUTE privilege on the routine
DATAACCESS authority
DBADM authority
SQLADM authority
WLMADM authority

Default PUBLIC privilege

None