File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-126
LISTLOCKS Listing Format
consecutive double quotes. A delimited module name in SQL/MX can contain
the circumflex character (^).
GRANTED
specifies to list only currently granted locks. Locks in a waiting state are not shown.
DETAIL
specifies that the internal LOCK STATE is displayed.
PARTONLY
specifies to list only the locks against the specified partition.
LISTLOCKS Listing Format
Example 2-10 shows the format the FUP LISTLOCKS command uses to display file
information. The first line lists the file name specified in the LISTLOCKS command.
LOCK TYPE
is the type of lock:
Note. The keywords, SYSTEM and USER, help distinguish user data from metadata.
The SYSTEM keyword can be used together only with the keyword CATALOG or
SCHEMA, to indicate the system metadata contained inside a catalog or schema. The
USER keyword can only be used with the CATALOG keyword to indicate the user
metadata contained inside a catalog. The set of tables defined by USER and those
defined by SYSTEM are mutually exclusive. The CATALOG or SCHEMA keyword
without the SYSTEM keyword, or the CATALOG keyword without the USER keyword,
indicates both the user data and the metadata.
The SCHEMA USER keyword is not supported and FUP returns an error if the parsed
ANSI name is of this type.
Example 2-10. FUP LISTLOCKS DETAIL Listing Format
\node.$volume.subvolume.file-id
LOCK REQUESTER KEY
TYPE STATE ID LEN KEY/RECORD ADDRESS
F G \FOXII.$:3:52:17484380
LOCK STATE = LK^X
FFile
RRecord
RG Generic record