 |
» |
|
|
|
This screen identifies the locks granted to a particular session
that are causing other sessions to wait.
To invoke the Lock Impede screen, use the i command from the Lock
subsystem or the /loc i command from other subsystems. When you invoke the screen, you must specify the
process identification number of a session.
You can specify the process identification
number on the command line, like this:
SQLMONITOR {{OVERVIEW}} => /loc i 18381
|
You can also specify the number in response to an SQLMON prompt,
for example:
SQLMONITOR {{OVERVIEW}} => /loc i
PID: 18381
|
The information in the NEW and WAITING fields, which
is displayed in inverse video, applies
to the sessions that are waiting for locks.
The other fields on the screen apply to the session
identified by the field in the upper left corner. Field Definitions | |
- REFRESH
The screen refresh rate, in seconds. - PID
The HP-UX
process identification number of the DBEnvironment session
you specified when you invoked this screen.
- 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 resource
The session has made a DBCore call, but
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.
See the "Concurrency Control through Locks and Isolation Levels"
chapter in the ALLBASE/SQL Reference Manual for more information.
- LOGIN NAME
The HP-UX login name for
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 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, usually the
parent process of the process actually connected to the DBEnvironment.
- G
The granularity of the lock, either
table (T), page (P), or row (R).
- OWNER.TABLE [/CONSTRAINT]
The name of the table
or referential constraint that is 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.
- GWC
The status of the lock, always set to G to indicate that the
lock has been granted to the session indicated by the PID field
in the upper left corner of the screen.
- MOD
The mode of lock that has been granted,
as follows: - 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
- NEW
The lock mode the waiting session is attempting to acquire.
If the lock has been granted, this field is blank.
- WAITING
The HP-UX process
identifier for the DBEnvironment session that is waiting
because an incompatible lock has been granted
to the session identified by the PID field in the upper left corner of the screen.
Related SET Commands | |
Use the SET REFRESH command to modify the refresh rate of the screen.
|
![[impede]](img/impede.gif)
