Displays information about all lock management locks in the
system, or about a specified lock.
Format
SHOW LOCKS [ lock-id
| /ADDRESS=n
| /ALL (d)
| /BRIEF
| /BLOCKING
| /CACHED
| /CONVERT
| /GRANTED
| /NAME=name
| /STATUS=(keyword[,...])
| /WAITING ]
or
SHOW LOCKS {/POOL | /SUMMARY}
1 – Parameter
lock-id
Name of a specific lock.
2 – Qualifiers
2.1 /ADDRESS
/ADDRESS=n
Displays a specific lock, given the address of the lock block.
2.2 /ALL
Lists all locks that exist in the system. This is the default
behavior of the SHOW LOCKS command.
2.3 /BLOCKING
Displays only the locks that have a blocking AST specified or
attached.
2.4 /BRIEF
Displays a single line of information for each lock.
2.5 /CACHED
Displays locks that are no longer valid. The memory for these
locks is saved so that later requests for locks can use them.
Cached locks are not displayed in the other SHOW LOCKS commands.
2.6 /CONVERT
Displays only the locks that are on the conversion queue.
2.7 /GRANTED
Displays only the locks that are on the granted queue.
2.8 /NAME
/NAME=name
Displays all locks on the specified resource. Name can be the
actual name of the resource, if it only contains uppercase
letters, numerals, the underscore (_), dollar sign, colon (:),
and some other printable characters, as for example, /NAME=MY_
LOCK. If it contains other printable characters (including
lowercase letters), you may need to enclose the name in quotation
marks (""), as for example, /NAME="My_Lock/47". If it contains
nonprintable characters, you can specify the name as a comma-
separated list comprised of strings and hexadecimal numbers. For
example, /NAME=("My_Lock",0C00,"/47") would specify the name "My_
Lock<NUL><FF>/47". The hexadecimal number can be no more than 8
digits (4 bytes) in length. Nonprintable sequences of more than
4 bytes must be split into multiple hexadecimal numbers. The
maximum length of a resource name is 32 characters.
2.9 /POOL
Displays the lock manager's poolzone information, which contains
the lock blocks (LKB) and resource blocks (RSB).
2.10 /STATUS
/STATUS=(keyword[,...])
Displays only the locks that have the specified status bits set
in the LKB$L_STATUS field. If you specify only one keyword, you
can omit the parentheses. Status keywords are as follows:
Keyword Meaning
2PC_IP Indicates a two-phase operation in progress
2PC_PEND Indicates a two-phase operation pending
ASYNC Completes request asynchronously
BLKASTFLG Specifies a blocking AST
BLKASTQED Indicates a blocking AST is queued
BRL Indicates a byte range lock
CACHED Indicates a lock block in cache
CVTSUBRNG Indicates a sub-range convert request
CVTTOSYS Converts back to system-owned lock
DBLKAST Delivers a blocking AST
DCPLAST Delivers a completion AST
DPC Indicates a delete pending cache lock
FLOCK Indicates a fork lock
GRSUBRNG Grants sub-range lock
IP Indicates operation in process
MSTCPY Indicates a lock block is a master copy
NEWSUBRNG Indicates a new sub-range request
NOQUOTA Does not charge quota
PCACHED Indicates lock block needs to be cached
PROTECT Indicates a protected lock
RESEND Resends during failover
RM_RBRQD Requires remaster rebuild
RNGBLK Specifies a range block
RNGCHG Indicates a changing range
TIMOUTQ Indicates lock block is on timeout queue
VALBLKRD Indicates read access to lock value block
VALBLKWRT Indicates write access to lock value block
WASSYSOWN Indicates was system-owned lock
2.11 /SUMMARY
Displays summary data and performance counters.
2.12 /WAITING
Displays only the waiting locks.