 |
» |
|
|
|
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 process identification number
when you invoke the screen. You can specify a process identification
number on the command line or in response to an SQLMON prompt:
SQLMONITOR {{OVERVIEW}} => /loc s 18827
SQLMONITOR {{OVERVIEW}} => /loc s
PID: 18827
|
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. - PID
The HP-UX 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 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.
For more information, see the chapter
"Concurrency Control through Locks and Isolation Levels"
in the ALLBASE/SQL Reference Manual.
- LOGIN NAME
The HP-UX login 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, 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 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 process 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. | Command | Description | Example |
|---|
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 | | SET LOCKFILTER | Filters the lock information provided.
| SET LOCKFILTER /U/TP/W/SXx/5 | | SET LOCKTABFILTER | Filters lock information by object name. |
SET LOCKTABFILTER PurchDB.Orders
|
|
![[lockses]](img/lockses.gif)
