System Administrator Guide > System Administrator Guide > Managing Workload > Monitoring the Workload Management System > ima_wlm_queues Table
Was this helpful?
ima_wlm_queues Table
The ima_wlm_queues table contains information on the queues for the current configuration.
Column Name
Type
Length
Nulls
Description
server
varchar
64
no
The DBMS server currently running
name
varchar
32
no
The name of the queue
priority
varchar
1
no
The priority of the queue
ratio
integer
4
no
The ratio number of the queue
cur_ratio
varchar
16
no
The highest ratio number of the queue.
If this column has a value, then this queue has been “ratio gated”. (Each resource being ratio gated is calculated independently.)
If this column has a value, then there are queries waiting in the wait list, but the queue is running less queries than its maximum concurrent query limit.
rw
varchar
16
no
Read/write setting for the queue:
R-Read
W-Write
blank-Read-write
active_limit
integer
4
no
Maximum number of active (running) queries allowed
cur_active
integer
4
no
Number of running queries
cur_waiting
integer
4
no
Number of waiting queries
est_cpu
varchar
16
no
Total estimated CPU for all active queries
est_dio
varchar
16
no
Total estimated disk I/O units for all active queries
maxwait
integer
4
no
Maximum time (in seconds) a query will wait in the wait list.
def
varchar
1
no
Whether this is the default queue for this configuration, indicated by an asterisk (*).
Last modified date: 08/29/2024