File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-128
LISTLOCKS Guidelines
LISTLOCKS Guidelines

Use the REPORTWIDTH option (from the CONFIGURE command) to set the
maximum length (in columns) for a subsequent LISTLOCKS listing.

The LISTLOCKS display for SQL files sometimes shows meaningless values in
one row; for example, a row of the number 255 (or all zeros).

An intent lock is internally generated by a disk process to control combinations of
record and file locks on a file. When a disk process receives a requester for a
record lock, it requests and receives an intent lock on the file. If the requested
record is not already locked, the record lock is granted.
An intent lock indicates that the holder has (or intends to have) one or more
records locked in a file. If a file lock has been issued against a file, intent locks are
not granted—but multiple intent locks can be granted against the same file.

A single LISTLOCKS report can contain inconsistencies (including record locks
that have no corresponding intent lock) because the status of locks can change
while the LISTLOCKS output is being prepared.

If a file has multiple partitions, the file (F) lock indicates a file lock against that
partition, not all partitions.

The LISTLOCKS command returns Error 48 when it is executed against a file on a
remote node and an incompatibility exists between the product version of FUP and
DP2 on the network. Execute the LISTLOCKS command from a copy of FUP
running on the remote node.

If you specify the primary partition of an Enscribe partitioned file, LISTLOCKS
displays lock information (if any) for all the partitions of the file.
LKDS Delete shared. This lock is a composite of LK^D and LK^S. It is a shared
lock for the row and a delete of one or more of the rows that precede the
locked row.
LKSIX Shared, intent exclusive. This lock is acquired for a table when an LK^IX
table lock exists and a user duration LK^S table lock is required for a scan.
LK^UX Unique, exclusive. This lock is acquired to protect a single row (no range
protection).
LKDUX Delete, unique exclusive. This lock is a composite of LK^D and LK^UX. It
describes a unique exclusive lock for the row and a delete of one or more
rows before the locked row.
LK^X Exclusive. This lock is acquired to provide exclusive protection for the row
that is locked and for the range between the locked row and the row before
it.
LK^DP2 DP2 key-link (either left or right key linklock). This is not a lock but is
maintained in the same manner. A key-link is an entity that helps DP2
process efficiency and is in the output of most utilities that display lock
information.