FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-139
LOADALTFILE Guidelines
key-file-number
selects the alternate-key file to load. Specify key-file-number as an integer in
the range 0 through 255 to indicate an alternate-key file of the primary file. The
alternate-key file must already exist. You can display the key-file number with the
FUP INFO command on the primary file. This number might be different from the
one used if you created the primary file with FUP.
primary-filename
names the existing primary file whose alternate-key records are to be generated
and loaded into the file indicated by key-file-number. Partial file names are
expanded using the current default node, volume, and subvolume names (if
necessary).
key-seq-option
specifies options for loading the alternate-key file.
MAX num-records
specifies the number of records to be read from primary-filename. The
default is 10,000,000. Specify num-records as a whole number in the range
0 through (512000000 * 2048) - 1. To determine the size of the scratch file that
is used by the SORT process, FUP multiplies num-records by the number of
alternate keys associated with key-file-number. The num-records value
should be equal to or greater than the actual number of records in the primary
file.
SCRATCH scratch-filename
specifies a file or volume to use for temporary storage while sorting. If you omit
this option, FUP uses a scratch file on the default volume.
DSLACK percentage
ISLACK percentage
SLACK percentage
specify the minimum percentage of space to reserve in the index and data
blocks for future insertions. If space is not available when an insertion is made,
a block split occurs.
LOADALTFILE Guidelines
ï‚·
To perform a LOADALTFILE operation, you must have read and write access to
the alternate-key files and read access to the primary file.
ï‚·
LOADALTFILE ignores any NO UPDATE specifications.
Note. For a complete description of these options, see LOAD on page 2-131.
To Next Page
Loading...
Need help?
General