FastSort Manual

Sorting From NonStop SQL/MP
FastSort Manual—429834-003
8-12
Configuring a CREATE INDEX Statement
DEFAULT [node-name] default-attr
specifies an attribute-value pair for partitions on a node for which no value has
been explicitly specified. If you omit node-name, SQL/MP applies the DEFAULT
statement to the node where the parallel index load is initiated. For more
information on how to use this option, see Assigning Default and Explicit Values on
page 8-14.
partition
specifies the name of the volume that contains the partition to which the specified
attributes apply. You can include a node name, such as:
$myvol
\nwreg.$sales1
The default is the local node.
CPU ( num [, num ] ... )
is valid only if you specify INDEX or BASETABLE. CPU specifies one or more local
CPUs for record generator or sort processes. You can specify multiple CPUs only
as DEFAULT CPUs.
NOSCRATCHON ( scratchvol [, scratchvol ] ...)
is valid only if you specify INDEX. NOSCRATCHON specifies one or more volumes
to be excluded as overflow scratch volumes for the sort process. You can use the
NOSCRATCHON option either as a DEFAULT specification or for a certain
partition. You cannot specify both SCRATCHON and NOSCRATCHON.
When selecting scratch volumes, FastSort consults this list if you do not use the
SCRATCHON option to specify a set of overflow scratch volumes. FastSort does
not use $SYSTEM or TMF audit trail volumes for overflow scratch files. Volumes
with less than 1 MB of disk space and volumes protected by the Safeguard product
are also exempt. You can use the NOSCRATCHON option either as a DEFAULT
specification or for a certain partition.
When you specify NOSCRATCHON volumes in a configuration file, the values you
specify override any values in a =_SORT_DEFAULTS DEFINE.
You can 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.
Caution. HP recommends that you use only a custom configuration file to configure a parallel
CREATE INDEX operation. If you omit the SCRATCH and SWAP attributes in your
configuration file and a =_SORT_DEFAULTS DEFINE contains fully qualified file names for
these attributes, processor and disk space contention problems can result.