FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-119
LISTLOCKS
By default, locks on all partitions of a partitioned Enscribe file are displayed. Use
LISTLOCKS to clarify lock situations. This command does not provide instantaneous
views of the locks.
OUT listfile
names a file or device to receive the listing output of the LISTLOCKS command.
You can use either a standard file name or a spool DEFINE name as the OUT
listfile. If listfile is an existing file, FUP appends output to it.
fileset-list
is a set of files for which to list existing locks (including SQL files and SQL object
files). You can use wild-card characters and can specify qualified-fileset.
ansiname-list
ansiname-list = ‘ansiname’ [ , ‘ansiname’ ]...
identifies SQL/MX ANSI Name catalogs, schemas, tables, indexes, partitions of
tables and indexes, and any combination of these objects. A single quote ( ' ) is
required to precede and delimit each ansiname. The ANSI names syntax is in
accordance with Unified Syntax Proposal. The syntax is:
SQL-name
is used to name SQL base objects (such as tables or indexes) in addition to
their SQL containers: catalogs and schemas. The names (called 3-part names)
for SQL base objects such as tables, indexes, or modules are composed of
three SQL identifiers separated by two dot characters (for example,
CAT.SCH.T).
LISTLOCKS [ / OUT listfile / ] fileset-list / ansiname-list
[ , GRANTED ] [ , DETAIL ] [ , PARTONLY ]
Note. For more information, see Specifying Files on page 1-8.
ansiname :: = CATALOG [SYSTEM | USER ] { * | SQL-names } |
SCHEMA [SYSTEM ] SQL-names |
{TABLE | INDEX} base-mx-object-names
SQL-names :: = SQL-name |( SQL-name [, SQL-name … ]... )
base-mx-object-names :: = base-mx-object-name |
( base-mx-object-name [, base-mx-object-name …] )
base-mx-object-name ::= SQL-name [ partitions ]
partitions :: = PARTITION (SQL-identifier [, SQL-identifier
…]...)
To Next Page
Loading...
Need help?
General