 |
» |
|
|
|
This screen displays lock activity data for
the entire DBEnvironment.
![[lock]](img/lock.gif)
To invoke the Lock screen, use the l command from the Lock
subsystem or the /loc command from other subsystems.
Field Definitions | |
- REFRESH
The screen refresh rate, in seconds.
- LOCKFILTER
The current setting of the LOCKFILTER
variable, which determines the type of lock information
that appears on the screen.
For more information, see 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 is a table lock, this field is blank.
- LOCK QUEUE
A list of characters. Each character represents
a lock that a DBEnvironment session has requested.
If a character appears in inverse video, the session is waiting
for a lock.
If a character appears without inverse video, the lock
has been granted.
If a character is in inverse video and underlined, the session
is converting the lock to a stronger mode.
The character indicates the mode of the lock, 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
When a session is waiting to acquire or convert a lock,
the character indicates
the lock mode the session is attempting to acquire.
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 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 |
|
