Description
INFORMIX System Monitoring Interface Tables
syssessions (Description of each user connected)
Column Type Description
sid int Session id
username char(8) User id
uid smallint User ID number
pid int Process id
connected int Time user connected to database
server
hostname char(16) Host name of client
tty char(16) Name of user's stderr file
feprogram char(16) Name of client application
state int Flags Hexidecimal Meaning
0x00000001 user structure in use
0x00000002 waiting for a latch
0x00000004 waiting for a clock
0x00000008 waiting for a buffer
0x00000010 waiting for a checkpoint
0x00000020 in a read RSAM call
0x00000040 writing logical log file to backup tape
0x00000080 ON Monitor
0x00000100 in a critical section
0x00000200 special demon
0x00000400 archiving
0x00000800 clean up dead processes
0x00001000 waiting for write of log buffer
0x00002000 special buffer flushing thread
0x00004000 remote database server
0x00008000 deadlock timeout used to set RS_timeout
0x00010000 regular lock timeout
0x00040000 waiting for a transaction
0x00080000 primary thread for a session
0x00100000 thread for building indexes
0x00200000 B tree clean thread