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------