Using SMI Tables

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Improving Individual Query Performance > Monitoring Sessions and Threads >

Using SMI Tables

Query the syssessions table to obtain the following information.

Column: Description
sid: Session ID
username: User name (login ID) of the user
uid: User ID
pid: Process ID
connected: Time that the session started
feprogram: Application that is running as the client (front-end program)

In addition, some columns contain flags that indicate if the primary thread of the session is waiting for a latch, lock, log buffer, or transaction; if it is an ON–Monitor thread; and if it is in a critical section.

Important:

The information in the syssessions table is organized by session, and the information in the onstat -u output is organized by thread. Also, unlike the onstat -u output, the syssessions table does not include information on daemon threads, only user threads.

Query the syssesprof table to obtain a profile of the activity of a session. This table contains a row for each session with columns that store statistics on session activity (for example, number of locks held, number of row writes, number of commits, number of deletes, and so on).

For a complete list of the syssessions columns and descriptions of syssesprof columns, see the chapter on the sysmaster database in the IBM Informix: Dynamic Server Administrator's Reference.