DB2 10.5 for Linux, UNIX, and Windows

WLM_GET_WORKLOAD_STATS table function - Return workload statistics

The WLM_GET_WORKLOAD_STATS function returns one row of workload statistics for every combination of workload name and database member number.

The functionality of WLM_GET_WORKLOAD_STATS is identical to the functionality of MON_GET_WORKLOAD_STATS. Although the functionality for these two routines is the same, the authorization is not necessarily the same. See MON_GET_WORKLOAD_STATS for syntax, parameters, information returned, 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