 |
» |
|
|
|
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
process identification number or the keyword ALL,
as shown in these examples:
SQLMONITOR {{OVERVIEW}} => /loc t all
SQLMONITOR {{LOCK}} => t 18827
|
The keyword ALL designates all sessions that are
connected to the DBEnvironment. You can also specify the process identification number
in response to a prompt generated by SQLMON, for example:
SQLMONITOR {{OVERVIEW}} => /loc t
PID [or ALL]: 18827
|
Field Definitions | |
- REFRESH
The screen refresh rate, in seconds. - PID
The HP-UX
process identification number you specified when you invoked
the screen.
If you specified ALL when you invoked the screen,
the value of PID is ALL.
- 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.
If the value of PID 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 PID 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 PID
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.
- LOGIN NAME
The HP-UX login name for the DBEnvironment session
you specified when you invoked the screen.
If the value of PID 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 PID
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 PID
is ALL, this field is not displayed.
- PROGRAM NAME
The name of the program being
run, usually the
parent process of the process actually connected to the DBEnvironment. If the value of PID
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 [/CONSTRAINT]
The name of the table
or referential constraint that is locked.
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 TOP | Limits the number of objects displayed
at each granularity level.
| SET TOP 10
|
|
![[tabsum]](img/tabsum.gif)
