WLM_GET_QUEUE_STATS table function - Return threshold queue statistics
The WLM_GET_QUEUE_STATS function returns basic statistics for one or more threshold queues on all active members. This function returns one row of statistics for each threshold queue.
The functionality of WLM_GET_QUEUE_STATS is identical to the functionality of MON_GET_QUEUE_STATS. Although the functionality for these two routines is the same, the authorization is not necessarily the same. See MON_GET_QUEUE_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