File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-134
LISTOPENS Examples

If the device (controlling process) does not support a LISTOPENS request, FUP
LISTOPENS displays:
WARNING - dev name: WILL NOT RETURN OPEN INFORMATION: ERR 2

LISTOPENS does not show a file as open if it was opened and closed during a
transaction (although the transaction itself is still open). This situation occurs
because the file has no openers. The INFO command does show as open files that
have been opened and closed during a transaction (if the transaction itself is still
open). This situation occurs because the file still has outstanding locks against it.

LISTOPENS displays the message Nonexistent process if the process that is
opening a file stops during the execution of the LISTOPENS command.

The user running FUP must have remote access to any system, which is implicitly
referenced by the ANSI name used in the FUP command. For example, if the ANSI
name is 'CATALOG*', the user must have access to any node on which any visible
catalogs reside, and so on. If the ANSI name is 'TABLE C.S.T', the user must have
access to any node on which partitions of table C.S.T reside, and so on. Users who
want to limit the scope of the command to all SQL/MX objects on the local machine
can use a Guardian wildcard of the form: $*.ZSD*.*.

The above explanation can be used to explain both an error 8551 from ANSI
names or error 48 from the file system, depending on the command that was used.

LISTOPENS supports SQL/MX objects, CATALOG, SCHEMA, TABLE, INDEX, and
PARTITIONS.

LISTOPENS command supports key-sequenced file with increased limits.
LISTOPENS Examples

To display a list of all processes that currently have open the file MYFILE (a file in
the current default volume and subvolume):
-LISTOPENS MYFILE

To list all the opens of terminal $TERM:
5>FUP LISTOPENS $TERM

To list all the opens of X.25 device $DEVICE.#NAME:
6>FUP LISTOPENS $DEVICE.#NAME

To list all temporary files on the current volume beginning with 4:
-LISTOPENS #4*

To display a list of all processes that currently have opened the SQL/MX objects:
FUP LISTOPENS 'SCHEMA CAT_ANSINAME01.SCH_ANSINAME01'
$DATA05.ZSDHKPKT.CGJC4500
ANSI NAME CAT_ANSINAME01.SCH_ANSINAME01.TAB1
PID MODE USERID SD MYTERM PROGRAM FILE NAME