FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-148
RELOAD
RELOAD
Physically reorganizes a key-sequenced file or SQL object (table or index only) while
allowing shared read and write access to the file or object.
FUP RELOAD supports key-sequenced file reorganization of volume directories, TMF-
audited files and SQL tables, and nonaudited files and SQL tables. A reload operation
improves access time and use of space for a key-sequenced file or SQL object that
has undergone many insertions, deletions, and updates with length changes.
FUP RELOAD supports SQL/MX ANSI names. FUP converts each ANSI name to the
corresponding list of Guardian file name and then performs RELOAD on these files.
OUT listfile
names a file or device to receive the output of the RELOAD 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 that file.
filename
is the name of the key-sequenced file or SQL object (table or index only) to be
reorganized. It can also be a secondary partition of a partitioned file. For more
information, see PARTOF $volume on page 2-150. You cannot use wild-card
characters or specify qualified-fileset for filename.
ansiname
identifies SQL/MX ANSI name table partition or an index partition. A single quote
( ' ) is required to precede and delimit ansiname.
Note. FUP support for fully qualified ANSI names for the RELOAD command is applicable on
H06.04 and subsequent RVUs.
RELOAD [ / OUT listfile / ] filename / ‘ansiname’
[ [ NO ] DEALLOCATE ]
[ , NEW ]
[ , PARTOF $volume ]
[ , RATE percentage ]
[ , DSLACK percentage ]
[ , ISLACK percentage ]
[ , SHARE ]
[ , SLACK percentage ]
[ , RECLAIM ]
[ , COMPACT ]
Note. For more information about listfile, see Specifying Files on page 1-8.
ansiname ::= {TABLE | INDEX} SQL-name PARTITION SQL-identifier
To Next Page
Loading...
Need help?
General