Was this helpful?
ima_wlm_sessions Table
The ima_wlm_sessions table shows session information.
Column Name
Type
Length
Nulls
Description
server
varchar
64
no
DBMS server the session exists in
session_id
varchar
32
no
Session ID of the session
effective_user
varchar
32
no
User ID of the session
session_group
varchar
32
no
Group ID of the session
session_role
varchar
32
no
Role ID of the session
user_priority
varchar
1
no
Wait list priority of the session for the session’s current queue
wlm_status
varchar
1
no
Status:
A-Active
W-Waiting
wlm_name
varchar
60
no
Queue that the session's current query is using
wlm_waitnum
integer
4
no
The current wait number of the session. If this number is greater than 0, then the query (session) is in a wait list. If this number is 1, then the query is the next one to run. If this number is X, then there are X-1 queries ahead of the query.
waittime
varchar
8
no
Time the session has been waiting in the wait list for the current query
runtime
varchar
8
no
Time the session has been running the current query
wlm_id
integer
4
no
An internally set ID number for the session
wlm_cpu
varchar
16
no
The estimated CPU usage for the session’s query
wlm_dio
varchar
16
no
The estimated disk I/O usage for the session’s query
session_query
varchar
4096
no
The current query run by the session
Last modified date: 03/21/2024