 |
» |
|
|
|
This screen displays session information for each program.
To invoke the Overview Program screen, use the p command
from the Overview subsystem or the /o p 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 of the DBEnvironment session.
- LOGIN NAME
The HP-UX login name
of 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.
For more information, 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 statement or a SET TRANSACTION statement.
- PROGRAM NAME
The name of the program being
run, usually the
parent process of the process actually connected to the DBEnvironment.
All of the sessions running a program are listed beneath the PROGRAM NAME.
Display Conventions | |
When a session is displayed in inverse video, it is waiting for a resource,
probably a lock. Related SET Commands | |
Use the SET REFRESH command to modify the refresh rate of the screen.
|
![[overprog]](img/overprog.gif)
