- REFRESH
The screen refresh rate, in seconds.
- LOCKFILTER
The current setting of the
LOCKFILTER variable, which determines
the type of lock information that is provided.
For more information, see the description of
the SET LOCKFILTER command.
- CID
The DBEnvironment connection identification number.
- PIN
The MPE/iX
process identification number 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.
- USER@ACCT
The MPE/iX user name and account name
of the DBEnvironment session.
- LABEL
The transaction label, equivalent to the LABEL column of
the SYSTEM.TRANSACTION pseudotable.
To assign a label to a transaction,
use either a BEGIN WORK or a SET TRANSACTION statement.
- 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.
- PROGRAM NAME
The name of the program being
run.
- G
The granularity of the lock, either
table (T), page (P), or row (R).
- OWNER.TABLE
[/CONSTRAINT]
The name of the table
or referential constraint that is locked.
- PAGE/ROW ID
The identifier of the page or row that is locked.
If the lock object is a table, this field is blank.
- GWC
The status of the lock, either granted (G), waiting (W), or
converting (C) to a stronger mode.
- MOD
The mode of lock that has been granted,
as listed below:
- S
Share
- X
Exclusive
- s
Intent share
- x
Intent exclusive
- 6
Share + intent exclusive
- R
Recovery exclusive
- r
Recovery intent exclusive
- v
Recovery share + intent exclusive
If the session is waiting for a lock, this field is blank.
If the session is converting a lock, the old value is displayed.
- NEW
The lock mode the waiting session is attempting to
acquire, just as listed under MOD.
If the lock has been granted, this field is blank.
- WAITS FOR
The connection identifier
of a session that has access to
the lock that the current session is waiting for.
Other sessions might also have access
to the lock. For a complete list of the sessions in the lock
queue, you can access the Lock Object screen.