 |
» |
|
|
|
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. - PID
The HP-UX
process identification number for the DBEnvironment session.
- LOGIN NAME
The HP-UX login 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.
|
![[overses]](img/overses.gif)
