File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-130
LISTOPENS

To display locks on SQL/MX index using ANSI names:
FUP LISTLOCKS 'INDEX CAT_ANSINAME01.SCH_ANSINAME01.IND1
PARTITION (IPART1)',DETAIL
$DATA05.ZSDHKPKT.DK8CK600
ANSI NAME CAT_ANSINAME01.SCH_ANSINAME01.IND1
LOCK REQUESTER KEY
TYPE STATE ID LEN KEY/RECORD ADDRESS
F GI \DRP42(2).2.7784507
LOCK STATE = LK^IX
R G \DRP42(2).2.7784507 8 ?0 ?0 ?0 ?12 ?0 ?0 ?0 ?11
LOCK STATE = LK^UX
LISTOPENS
Lists the processes that have files open from the files specified in the command and
provides other related information.
LISTOPENS supports SQL/MX ANSI names. FUP converts each ANSI name to the
corresponding list of Guardian file names, then performs LISTOPENS on each of these
files, and displays information of the opened files only.
OUT listfile
names a file or device to receive the listing output of the LISTOPENS command.
You can use either a Guardian file name or a spool DEFINE name as the OUT
listfile. If listfile is an existing file, FUP appends output to that file.
fileset-list
is a list of files or devices for which opens are to be displayed—including Enscribe
files and all types of SQL/MP or SQL/MX files (except SQL/MP shorthand views).
You can use wild-card characters. You cannot specify qualified-fileset for
fileset-list. The fileset-list parameter can include device names in any
of these forms:
$device
$device.#name
[$device].#number
Note. FUP support for fully qualified ANSI names for the LISTOPENS command is applicable
on H06.04 and subsequent RVUs.
LISTOPENS [ / OUT listfile / ] fileset-list / ansiname-list
[ , SCRATCH scratch-filename ]
Note. For more information, see Specifying Files on page 1-8.