MON_GET_WLM_ADMISSION_QUEUE table function - Return a list of queued activities

The MON_GET_WLM_ADMISSION_QUEUE function returns a list of all activities in the admission queue and their position in the queue.

MON_GET_WLM_ADMISSION_QUEUE returns all requests in the workload manager (WLM) admission queue, and their position in each subclass queue.
Note: This function is available in Db2®version 11.5.4 and later.

Authorization

One of the following authorities is required to execute the routine:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

None

Syntax

Read syntax diagramSkip visual syntax diagramMON_GET_WLM_ADMISSION_QUEUE()

The schema is SYSPROC.

Routine parameters

None

Information returned

Table 1. Information returned for MON_GET_WLM_ADMISSION_QUEUE
Column name Data type Description
SERVICE_SUPERCLASS_NAME VARCHAR(128) service_superclass_name - Service superclass name monitor element
SERVICE_SUBCLASS_NAME VARCHAR(128) service_subclass_name - Service subclass name monitor element
ADM_QUEUE_POSITION BIGINT adm_queue_position - Admission queue position monitor element
MEMBER SMALLINT member - Database member
ADM_QUEUE_ENTRY_TIME TIMESTAMP adm_queue_entry_time - Admission queue entry time monitor element
APPLICATION_HANDLE BIGINT application_handle - Application handle monitor element
UOW_ID BIGINT uow_id - Unit of work ID monitor element
ACTIVITY_ID BIGINT activity_id - Activity ID monitor element
SESSION_PRIORITY VARCHAR(10) session_priority - Session priority monitor element
ADM_RESOURCE_ACTUALS CHAR(1) adm_resource_actuals - admission control resource actuals monitor element
ESTIMATED_RUNTIME BIGINT estimated_runtime - Estimated execution time for a DML statement monitor element
EFFECTIVE_QUERY_DEGREE BIGINT effective_query_degree - Effective query degree monitor element
ESTIMATED_SORT_SHRHEAP_TOP BIGINT estimated_sort_shrheap_top - Estimated shared sort heap consumption monitor element
ESTIMATED_UTIL_HEAP_TOP BIGINT estimated_util_heap_top - estimated peak utility heap monitor element

Usage notes

The workload manager admission queue is constantly being reordered based on current resource usage and demand as queries are executed and admitted. As such the data returned is a point in time snapshot of the current state of the admission queue does not necessarily reflect the future execution order. Use this monitor interface to understand which request is currently at the head of the queue since the head request may block additional work from entering as it is waiting for its required resources.
Note: If the adaptive workload manager is disabled, no data is returned.