HP 3000 Manuals

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

ALLBASE/SQL Performance and Monitoring Guidelines

Lock Session Screen

This screen displays lock activity data for a single session.

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

You must specify the session's connection identification number when you
invoke the screen. You can specify a connection identification number on
the command line or in response to an SQLMON prompt:

SQLMONITOR OVERVIEW => /loc s 2

SQLMONITOR OVERVIEW => /loc s

CID: 2

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 is
provided.

For more information, see the description of the SET
LOCKFILTER command.

CID The DBEnvironment connection identification number.

PIN The MPE/iX process identification number of the
DBEnvironment session.

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.

XID The transaction identifier, equivalent to the XID column
of the SYSTEM.TRANSACTION pseudotable.

ISO The isolation level, equivalent to the ISOLATION LEVEL
column of the SYSTEM.TRANSACTION pseudotable. 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 of the
DBEnvironment session.

LABEL The transaction label, equivalent to the LABEL column of
the SYSTEM.TRANSACTION pseudotable. To assign a label
to a transaction, use either a BEGIN WORK or a SET
TRANSACTION statement.

PRI The transaction priority, equivalent to the PRIORITY
column of the SYSTEM.TRANSACTION pseudotable. The
lowest transaction priority is 255, and the highest is
0.

PROGRAM NAME The name of the program being run.

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 object is a table, this field is blank.

GWC The status of the lock, either granted (G), waiting (W),
or converting (C) to a stronger mode.

MOD The mode of lock that has been granted, 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

If the session is waiting for a lock, this field is
blank. If the session is converting a lock, the old
value is displayed.

NEW The lock mode the waiting session is attempting to
acquire, just as listed under MOD. If the lock has been
granted, this field is blank.

WAITS FOR The connection identifier of a session that has access
to the lock that the current session is waiting for.
Other sessions might also have access to the lock. For
a complete list of the sessions in the lock queue, you
can access the Lock Object screen.

Display Conventions

If the session appears in inverse video, it is waiting for a lock. If
the session appears in inverse video and underlined, it is converting a
lock to a stronger mode. If the session appears without inverse video or
underlining, the lock has been granted.

Related SET Commands

The SET commands in the following table affect this screen.

MPE/iX 5.0 Documentation