FastSort Manual

Sorting From NonStop SQL/MP
FastSort Manual—429834-003
8-13
Configuring a CREATE INDEX Statement
NUMRECS ( number )
is valid only if you specify INDEX. NUMRECS specifies the approximate number of
records to load into the index partition. Use NUMRECS if the index is unevenly
partitioned across volumes. FastSort uses this number to calculate initial scratch
file size.
PRI ( priority )
is valid only if you specify INDEX or BASETABLE. PRI specifies the priority at
which to run the record generator or sort process.
PROGRAM (filename )
specifies the name of a local or remote SORTPROG object file if you also specify
BASETABLE. If you specify INDEX, PROGRAM specifies the name of a local or
remote RECGEN object file. The associated swap volume must reside on the
same node as the object file.
SCRATCH ( scratchvol [, scratchvol ]...)
is valid only if you specify INDEX. SCRATCH specifies the name of an initial
scratch volume or volumes FastSort can use to sort index records. When you
specify scratch volumes in a configuration file, the values you specify override any
values in a =_SORT_DEFAULTS DEFINE.
You can specify a list of SCRATCH volumes only in DEFAULT syntax. When you
use SCRATCH to list default scratch volumes, FastSort assigns one volume to
each sort process in a sequential fashion. If there are more index partitions than
volumes available, FastSort reuses volumes on the list until each partition has an
initial scratch volume. You can use the SCRATCH option either as a DEFAULT
specification or for a certain partition.
The SCRATCH option specifies initial scratch volumes. Use the SCRATCHON
option to specify a set of overflow volumes. To direct FastSort to set up an overflow
scratch volume pool by excluding certain volumes, use the NOSCRATCHON
option.
SCRATCHON ( scratchvol [, scratchvol ]...)
is valid only if you specify INDEX. SCRATCHON specifies one or more volumes
FastSort can use for overflow scratch files. FastSort uses overflow scratch
volumes only if one or more initial volumes becomes full, or if you do not use the
SCRATCH option to specify an initial scratch volume. You can use the
SCRATCHON option either as a DEFAULT specification or for a certain partition.
You can specify up to 32 scratch volumes, within the maximum line length of 132
characters. You can also use the wild-card characters * and ? when you specify
scratchvol. See the description of SCRATCHON in Section 7, Using SORT and
SUBSORT DEFINEs for examples of how to use these characters.