session_list

A more comprehensive list than the user_list.

This takes information from the sysmaster database so can only be used with the database up.

All information from syssesprof, syssessions and syssqlstat. Then using sysuserthrads, syslocktab, sysconditions and systcblst get additional information about the session, such as what it’s waiting for and how much cpu time its used

session_list

column sysmaster description
sid syssesprof session id
lockreqs syssesprof number of times a lock was requested
locksheld syssesprof number of locks held
lockwts syssesprof number of times had to wait for a lock
deadlks syssesprof number of times had a dead lock
lktouts syssesprof number of times a lock wait timed out
logrecs syssesprof number of logical log records written by this session
isreads syssesprof isam read operations
iswrites syssesprof isam write operations
isrewrites syssesprof isam re-write operations
isdeletes syssesprof isam delete operations
iscommits syssesprof isam commit operations
isrollbacks syssesprof isam rollback operations
longtxs syssesprof number of long transactions
bufreads syssesprof number of times read a buffer
bufwrites syssesprof number of times write to a buffer
seqscans syssesprof number of times tables were sequentially scanned
pagreads syssesprof number of times a page was read
pagwrites syssesprof number of times a page was written
total_sorts syssesprof total number of sorts
dsksorts syssesprof sorts that had to be performed on disk
max_sortdiskspace syssesprof maximum disk space used by a sort
logspused syssesprof number of bytes of logical log space used
maxlogsp syssesprof maximum log space used by session
username syssessions user who owns the session
userid syssessions user id of owner of the session
pid syssessions process id of client
hostname syssessions host of client process
tty syssessions tty of client process
connected syssessions time stamp when session connected
feprogram syssessions identify of client software
pooladdr syssessions session pool address
is_wlatch syssessions 1=session waiting for a latch
is_wlock syssessions 1=session waiting for a lock
is_wbuff syssessions 1=session waiting for a buffer
is_wckpt syssessions 1=session waiting for a check point
is_wlogbuf syssessions 1=session waiting for a logical log buffer
is_wtrans syssessions 1=session waiting for a transaction
is_monitor syssessions 1=process is monitor
is_incrit syssessions 1=process is in critical section
state syssessions flags describing state of session
sqs_dbname syssqlstat name of database connected to
sqs_iso syssqlstat isolation level of sql statement
sqs_lockmode syssqlstat lock mode of sql statement
sqs_sqlerror syssqlstat sql error, if any
sqs_isamerror syssqlstat isam error, if any
sqs_feversion syssqlstat version of client on front end
sqs_statement syssqlstat current sql statement text
lockmode infx description of session lock mode
isolevel infx description of isolation level
waitfor infx descriptive text of what is being waited for
class infx class for status of sessione.g.good, bad, warn
condate infx decoded connection time stamp
location infx description of where session comes from (host/tty)
sql_statement infx sql being executed
sql_short infx short description of sqle.g.select, update, insert