Lock Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
Lock Screen
This screen displays lock activity data for the entire DBEnvironment.
Click here to view figure.
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 The name of the table or referential constraint that is
[/CONSTRAINT] 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 | SET REFRESH 5 |
| | of the screen. | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| SET LOCKFILTER | Filters the lock | SET LOCKFILTER /U/TP/W/SXx/5 |
| | information provided. | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| SET LOCKTABFILTER | Filters lock information | SET LOCKTABFILTER PurchDB.Orders |
| | by object name. | |
| | | |
----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals