SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-9
Specifying Configuration for Parallel Index Loading
NUMRECS ( number )
is valid only if INDEX is specified and specifies the approximate number of records
to be loaded into the index partition. This number is used to calculate the scratch
file size, as described in the FastSort Manual. If this number is too small, the sort
process might fail with sort error 30 and file-system error 45 (File is full). Use this
attribute if the index is not partitioned evenly across all volumes.
PRI ( priority )
is valid only if INDEX or BASETABLE is specified, and specifies the priority at
which the record generator or sort process is to run.
PROGRAM ( file-name )
specifies the name of a local or remote SORTPROG object file if BASETABLE is
also specified, or specifies the name of a local or remote RECGEN object file if
INDEX is also specified. The associated swap volume must reside on the same
node as the object file.
SCRATCH ( scratchvol [, scratchvol ]... )
is valid only if INDEX is specified. SCRATCH specifies the name of an initial local
or remote scratch volume or volumes where the sort process can sort index
records. When you specify a list of scratch volumes in a DEFAULT specification,
FastSort assigns one volume to each sort process (each associated with a
partition) in a sequential fashion. If there are more partitions than volumes,
FastSort reuses the list as needed until all partitions have an initial scratch volume
assigned.
The SCRATCH option specifies volumes for use as initial scratch volumes. This is
not the same as overflow handling. To specify a set of volumes for overflow, use
the SCRATCHON option. To request an overflow pool but exclude specific
volumes, use the NOSCRATCHON option.
If SMF is installed on the node you specify, scratchvol can be a virtual or
physical volume. If you specify a virtual volume, FastSort ignores any volumes
specified in SCRATCHON or NOSCRATCHON and uses only the virtual volume for
both initial and overflow scratch files.
SCRATCHON ( scratchvol [, scratchvol ] ...)
is valid only if INDEX is specified. SCRATCHON specifies one or more volumes to
be used as overflow scratch volumes for the sort process—in case one or more
initial volumes become full. The sort processes also use this list if you do not
specify an initial set of scratch volumes (using the SCRATCH option). The
SCRATCHON option can be used as a DEFAULT specification or for a specific
partition.