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