This screen identifies the sessions in the lock queue for
a particular table, page, or row.
![[lockobj]](img/lockobj.gif)
To invoke the Lock Object screen, use the o command from the Lock
subsystem or the /loc o command from other subsystems.
By default, the LOCKOBJECT variable is set to ALL. Therefore,
by default, the LOCK OBJECT screen
displays all the lock objects that qualify under
the LOCKFILTER and LOCKTABFILTER variables.
If LOCKOBJECT is set to OFF, you must specify a lock
or ALL when you invoke the Lock Object screen.
For example, to view information about all the qualified locks,
you can enter
SQLMONITOR {{OVERVIEW}} => /loc o ALL
|
To view information about a single lock on a table,
you must provide the table name:
SQLMONITOR {{OVERVIEW}} => /loc o PurchDB.Parts
|
If the lock is on a page or row, you must
provide the table name and the page or row id,
separating the two fields with a slash:
SQLMONITOR {{OVERVIEW}} => /loc o PurchDB.Parts/0:1:5:28
SQLMONITOR {{OVERVIEW}} => /loc o PurchDB.Parts/0 1 5 28
|
As shown in the last two examples, you can use either spaces or
colons to delimit the numbers in the page or row id.
Field Definitions |
 |
- REFRESH
The screen refresh rate, in seconds.
- LOCKFILTER
If the lock object is ALL,
the current setting of the LOCKFILTER variable.
The LOCKFILTER variable determines the type of lock
information that is provided.
For more information, see the description of
the SET LOCKFILTER command.
- 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 lock status, 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, this field displays
the old value.
- NEW
The lock mode the waiting session is attempting to acquire.
If the lock has been granted, this field is blank.
- CID
The DBEnvironment connection identification number.
- PIN
The MPE/iX process identification number.
- USER@ACCT
The MPE/iX user name and account name.
- 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 "Concurrency Control through Locks and Isolation Levels"
chapter in the ALLBASE/SQL Reference Manual for more information.
- 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.
- PROGRAM NAME
The name of the program being
run.
Display Conventions |
|
Sessions waiting for locks appear on the screen in inverse video.
If the session is converting the lock to a stronger mode,
the fields are in inverse video and underlined.
The absence of inverse video and underlining indicates that
the lock has been granted.
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 LOCKOBJECT | Specifies the lock object displayed. When set to ALL, the screen displays all lock objects that qualify under the LOCKFILTER and LOCKTABFILTER variables. | SET LOCKOBJECT PurchDB.Parts |
| SET LOCKFILTER | Filters the lock information provided. | SET LOCKFILTER /U/TP/W/SXx/5 |
| SET LOCKTABFILTER | Filters lock information by object name. | SET LOCKTABFILTER PurchDB.Orders |
