1 /ADDRESS
/ADDRESS=n Displays a specific lock, given the address of the lock block.
2 /ALL
Lists all locks that exist in the system. This is the default behavior of the SHOW LOCKS command.
3 /BLOCKING
Displays only the locks that have a blocking AST specified or attached.
4 /BRIEF
Displays a single line of information for each lock.
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.
6 /CONVERT
Displays only the locks that are on the conversion queue.
7 /GRANTED
Displays only the locks that are on the granted queue.
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.
9 /POOL
Displays the lock manager's poolzone information, which contains the lock blocks (LKB) and resource blocks (RSB).
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
11 /SUMMARY
Displays summary data and performance counters.
12 /WAITING
Displays only the waiting locks.