File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-127
LISTLOCKS Listing Format
STATE
is the state of the lock:
REQUESTER ID
is either a named or unnamed process (or a transaction ID).
KEY LEN
is the key length.
KEY/RECORD ADDRESS
is a key value for each locked record according to the type of file:

For key-sequenced files, the key value is displayed. This value can wrap
around to the next line.

For unstructured files, the relative byte address is displayed.

For entry-sequenced files, the record address is displayed.

For relative record files, the record number is displayed. The key field cannot
be longer than the generic lock length for generic key locks.
LOCK STATE
specifies the size and range of the lock.
G Granted
I Internally generated intent lock
W Waiting
LK^IS Intent shared. This lock is acquired for the table only. You can upgrade it to
LK^S when escalation to a table lock is required.
LK^IX Intent exclusive. This lock is acquired for the table only. You can upgrade it
to LK^X when escalation to a table lock is required.
LK^R Range check. This lock assures that the range is not protected by another
lock before an insert. It is always released after it is granted.
LK^US Unique shared. This lock is acquired to protect a single row (no range
protection).
LK^S Shared. This lock protects an entire table if granted for the table. Otherwise
it protects the row that is locked and the range between the locked row and
the row that precedes it.
LK^D Delete. This lock is acquired for the row after a deleted row. Use it to prevent
scans from skipping uncommitted deletes.
LKDUS Delete. This lock is acquired for the row after a deleted row. Use it to prevent
scans from skipping uncommitted deletes.