Lock Memory Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
Lock Memory Screen
This screen lists the number of locks allocated to each session according
to the lock granularity.
Click here to view figure.
To invoke the Lock Memory screen, use the m command from the Lock
subsystem or the /loc m command from other subsystems.
Field Definitions
REFRESH The screen refresh rate, in seconds.
SESSIONS The number of DBEnvironment sessions.
SORTLOCK An indicator of how the sessions are sorted. The
sessions are sorted in descending order by the value in
the column indicated by the asterisk. In the example
above, the sessions are sorted by MAXTOTAL values. For
more information, see the description of the SET
SORTLOCK command.
CID The DBEnvironment connection identification number.
TABLE The number of table locks allocated to the session.
This number includes locks that have been granted, locks
the session is waiting to acquire, and locks the session
is waiting to convert.
PAGE The number of page locks allocated to the session. This
number includes locks that have been granted, locks the
session is waiting to acquire, and locks the session is
waiting to convert.
ROW The number of row locks allocated to the session. This
number includes locks that have been granted, locks the
session is waiting to acquire, and locks the session is
waiting to convert.
TOTAL The total number of locks allocated to the session,
calculated as follows:
TOTAL = TABLE + PAGE + ROW
MAXTOTAL The maximum number of TOTAL locks allocated to the
session since it was attached to the DBEnvironment.
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 SORTLOCK | Sorts sessions in descending order | SET SORTLOCK 2 |
| | according to the value of the specified | |
| | column. | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SET TOP | Limits the number of sessions displayed. | SET TOP 10 |
| | | |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation
HP 3000 Manuals