Monitor sessions and threads with ON-Monitor (UNIX)
On (UNIX™), you can
use ON-Monitor to view information about sessions and user threads.
This information is a subset of the information that the onstat
-u command displays.
Choose User from the Status menu. The following information
appears:
The session ID
The user ID
The number of locks that the thread is holding
The number of read calls and write calls that the thread has executed
Flags that indicate the present state of the thread (for example,
waiting for a buffer or waiting for a checkpoint), whether the thread
is the primary thread for a session, and what type of thread it is
(for example, user thread, daemon thread, and so on)
The following figure shows sample output.Figure 1: Output from the User option
of the ON-Monitor Status menu
USER THREAD INFORMATION
Locks Disk Disk User thread
Session User Held Reads Writes Status
0 informix 0 96 2 ------D
0 informix 0 0 0 ------F
0 informix 0 0 0 -------
15 informix 0 0 0 Y-----M
0 informix 0 0 0 ------D
17 chrisw 1 3 34 Y------