User Session Information
This last set of SMI tables deals with users and information about their sessions. These tables were used in our example script "dbwho" at the beginning of this chapter.
| • Syssessions | Session data |
| • Syssesprof | User statistics |
| • Syslocks | User locks |
| • Syseswts | Wait times |
User session and connection information: syssessions
This view contains information from two shared memory structures, the user control and thread control table. This tells you who is logged in to your server and some basic data about their session.
View syssessions
Column Data Type Description Sid integer Session id number Username char(8) User name uid smallint User UNIX or NT id pid integer User process id hostname char(16) Hostname tty char(16) TTY ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
