Exploring user sessions

You can view and stop user sessions using the Session Explorer.

To see what sessions are currently running at the server, expand Performance Analysis > Session Explorer.

To view any of the sessions running at the server:

  1. On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, click Performance Analysis > Session Explorer.
  2. Click the session ID number (SID). The Session Info page opens. This page contains statistics about the session, including user name, when the user connected to the server, memory used, and open tables.
  3. Click the tabs to display additional performance information about the session:
    Tab name Description
    SQL SQL commands run by the session.
    Locks Locks held by the session.
    Threads Threads run by the session.
    Memory Memory used by the session
    Network I/O data for the session.
    Environment Environment variable values for the session.
    Profile Summary performance information about the session.

Copyright© 2018 HCL Technologies Limited