 |
» |
|
|
|
This screen displays lock activity data for
the entire DBEnvironment.
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
|
|
![[lock]](img/lock.gif)
