 |
» |
|
|
|
This screen identifies all sessions connected to the
DBEnvironment.
To invoke the Overview Session screen, use the s command
from the Overview subsystem or the /o s command from
other subsystems. Field Definitions |  |
- REFRESH
The screen refresh rate, in seconds.
- SESSIONS
The number of DBEnvironment sessions.
- CID
The DBEnvironment connection identification number.
- PIN
The MPE/iX
process identification number of the DBEnvironment session.
- USER@ACCT
The MPE/iX user name and account name for
the DBEnvironment session.
- STATUS
The status of the DBCore call the session has made.
This field is equivalent to the STATUS column of
the SYSTEM.CALL pseudotable. The possible values are listed below:
- Running
DBCore is processing a call from a session.
- Waiting for resource
The session has made a DBCore call, but
is waiting until it can acquire a resource that is currently unavailable.
The resource can be LOCK, LATCH, BUFFER,
THROTTLE, or XACT.
- Idle
DBCore is not processing a call.
- XID
The transaction identifier,
equivalent to the XID column of
the SYSTEM.TRANSACTION pseudotable.
- ISO
The isolation level,
equivalent to the ISOLATION LEVEL column of
the SYSTEM.TRANSACTION pseudotable.
See the chapter "Concurrency Control through Locks and Isolation Levels"
in the ALLBASE/SQL Reference Manual.
- PRI
The transaction priority,
equivalent to the PRIORITY column of
the SYSTEM.TRANSACTION pseudotable.
The lowest transaction priority is 255, and the highest is 0.
- LABEL
The transaction label,
equivalent to the LABEL column of
the SYSTEM.TRANSACTION pseudotable.
To assign a label to a transaction,
use a BEGIN WORK or a SET TRANSACTION statement.
Display Conventions |  |
When a session is displayed in inverse video, the session
is waiting for a resource, probably a lock. Related SET Commands |  |
Use the SET REFRESH command to modify the refresh rate of the screen.
|