4. Monitoring Server Information : Session List Screen
Share this page                  
Session List Screen
The Session List screen appears when you select Sessions from the Server List screen. This pop-up screen displays the sessions for the selected server. The selected server is the one on which the cursor rests in the Server List.
The Session List screen has the following columns:
Uniquely identifies the session.
Name of the session. This is a scrollable field; move the cursor to the field and use the arrow keys to see the entire contents.
Internal sessions are displayed with angle brackets <>. The bracketed internal sessions are available only if the option (Display Internal Sessions?) in the options panel is set to y. The default setting is n. Session names for user sessions are usually the same as the user name. (Both the user name and session name are shown under More_Info).
Terminal name, if known. Network and internal sessions do not show a terminal.
The database to which the session is currently connected.
State of the session. Use the Find menu item to search this column. The following states are shown. Note that these states are not identical in meaning for internal sessions, such as the Fast Commit Thread:
The session is waiting for client communications.
The session is computable; it is not waiting for the user or for I/O.
The session is waiting for disk I/O.
The session is about to terminate.
The session is waiting for another session to release locks. The wait continues until the other session completes its transaction.
The session is waiting for output to the log file.
The session is waiting for another session to complete accessing an internal data structure. The wait continues only until the other session is done accessing.
The server facility currently handling the session. The More_Info screen spells out the meaning of the facility acronym. Examples are:
Data Manipulation Facility
Optimizer Facility
Query Execution Facility
The first 24 characters of the query currently running is shown. This field is displayed only if the user running IPM is a privileged user.
The More_Info screen shows more of the query. The query is shown only if it is current. A current query is one being processed by the Ingres DBMS Server, not a query that has returned results and finished executing, even though the user has not committed.