HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Lock Screen 

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      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