HP 3000 Manuals

Lock TabSummary Screen [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation

ALLBASE/SQL Performance and Monitoring Guidelines

Lock TabSummary Screen

This screen displays summarized information about the locks a session
holds. The locks are grouped by granularity, that is, by table locks,
page locks, and row locks. You can display lock information for a single
session or for all sessions connected to the DBEnvironment.

To invoke the Lock screen, use the t command from the Lock subsystem or
the /loc t command from other subsystems.

When you invoke the screen, you must specify either a connect
identification number or the keyword ALL to designate the sessions you
are interested in. The keyword ALL designates all sessions that are
connected to the DBEnvironment.

You can specify the connect identification number (or ALL) on the command
line or in response to a prompt generated by SQLMON, for example:

SQLMONITOR OVERVIEW => /loc t all

SQLMONITOR LOCK => t 1

SQLMONITOR OVERVIEW => /loc t

CID [or ALL]: 1

Field Definitions

REFRESH The screen refresh rate, in seconds.

CID The DBEnvironment connection identification number. If
you specified ALL when you invoked the screen, the value
of CID is ALL.

PIN The MPE/iX process identification number of the
DBEnvironment session. If the value of CID is ALL, this
field is not displayed.

STATUS The status of the DBCore call the session has made.
This field is equivalent to the STATUS column of the
SYSTEM.CALL pseudotable. The possible values are listed
below:

Running DBCore is processing a call from a
session.

Waiting for The session has made a DBCore call, but
resource is waiting until it can acquire a
resource that is currently unavailable.
The resource can be LOCK, LATCH,
BUFFER, THROTTLE, or XACT.

Idle DBCore is not processing a call.

If the value of CID is ALL, this field is not displayed.

XID The transaction identifier, equivalent to the XID column
of the SYSTEM.TRANSACTION pseudotable. If the value of
CID is ALL, this field is not displayed.

ISO The isolation level, equivalent to the ISOLATION LEVEL
column of the SYSTEM.TRANSACTION pseudotable. If the
value of CID is ALL, this field does not appear.

For more information, see the chapter "Concurrency
Control through Locks and Isolation Levels" in the
ALLBASE/SQL Reference Manual.

USER@ACCT The MPE/iX user name and account name for the
DBEnvironment session you specified when you invoked the
screen. If the value of CID is ALL, this field is not
displayed.

LABEL The transaction label, equivalent to the LABEL column of
the SYSTEM.TRANSACTION pseudotable. To assign a label
to a transaction, use either the BEGIN WORK or SET
TRANSACTION statement. If the value of CID is ALL, this
field is not displayed.

PRI The transaction priority, equivalent to the PRIORITY
column of the SYSTEM.TRANSACTION pseudo-table. The
lowest transaction priority is 255 and the highest is 0.
If the value of CID is ALL, this field is not displayed.

PROGRAM NAME The name of the program being run.

If the value of CID is ALL, this field is not displayed.

TOTAL LOCKS The total number of lock control blocks.

G The granularity of the lock control blocks, either table
(T), page (P), or row (R).

OWNER.TABLE The name of the table or referential constraint that is
[/CONSTRAINT] locked.

Related SET Commands

The SET commands in the following table affect this screen.

MPE/iX 5.0 Documentation