HP 3000 Manuals

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.

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.

MPE/iX 5.0 Documentation