 |
» |
|
|
|
This screen displays summarized information about the locks
a session holds.
The locks are grouped by granularity, that
is, by table locks, page locks, and row locks.
You can display lock information for
a single session or for all sessions connected to the
DBEnvironment.
![[tabsum]](img/tabsum.gif)
To invoke the Lock screen, use the t command from the Lock
subsystem or the /loc t command from other subsystems.
When you invoke the screen, you must specify either a
connect identification number or the keyword ALL to
designate the sessions you are interested in.
The keyword ALL designates all sessions that are
connected to the DBEnvironment.
You can specify the connect identification number (or ALL)
on the command line or in response to a prompt generated by SQLMON,
for example:
SQLMONITOR {{OVERVIEW}} => /loc t all
SQLMONITOR {{LOCK}} => t 1
SQLMONITOR {{OVERVIEW}} => /loc t
CID [or ALL]: 1
|
Field Definitions | |
- REFRESH
The screen refresh rate, in seconds.
- CID
The DBEnvironment connection identification number.
If you specified ALL when you invoked the screen,
the value of CID is ALL.
- PIN
The MPE/iX
process identification number of the DBEnvironment session.
If the value of CID is ALL, this field is not displayed.
- 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.
If the value of
CID
is ALL, this field is not displayed.
- XID
The transaction identifier, equivalent to the XID column of
the SYSTEM.TRANSACTION pseudotable.
If the value of
CID
is ALL, this field is not displayed.
- ISO
The isolation level,
equivalent to the ISOLATION LEVEL column of
the SYSTEM.TRANSACTION pseudotable.
If the value of
CID
is ALL, this field does not appear.
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
for the DBEnvironment session you specified when you invoked
the screen.
If the value of CID is ALL, this field is not displayed.
- LABEL
The transaction label, equivalent to the LABEL column of
the SYSTEM.TRANSACTION pseudotable.
To assign a label to a transaction,
use either the BEGIN WORK or SET TRANSACTION statement.
If the value of
CID
is ALL, this field is not displayed.
- PRI
The transaction priority, equivalent to the PRIORITY column of
the SYSTEM.TRANSACTION pseudo-table.
The lowest transaction priority is 255 and the highest is 0.
If the value of
CID
is ALL, this field is not displayed.
- PROGRAM NAME
The name of the program being
run.
If the value of
CID
is ALL, this field is not displayed.
- TOTAL LOCKS
The total number of lock control blocks.
- G
The granularity of the lock control blocks,
either table (T), page (P), or row (R).
- OWNER.TABLE [/CONSTRAINT]
The name of the table
or referential constraint that is locked.
Related SET Commands | |
The SET commands in the following table affect this screen. | Command | Description | Example |
|---|
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 | | SET TOP | Limits the number of objects displayed at each granularity level. | SET TOP 10 |
|
