SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

631

632

633

634

635

636

637

638

639

640

HP NonStop SQL/MP Reference Manual—523352-013

P-8

Specifying Configuration for Parallel Index Loading

preserve software behavior available in NonStop SQL/MP versions prior to version

315.

If you do not specify LOCALONLY, each SORTPROG or RECGEN process runs

on the node where the associated partition resides.

If you specify LOCALONLY, it must be the first CREATEINDEX statement in the

configuration file.

BASETABLE

indicates attributes apply to processes that read the base table partition.

INDEX

indicates attributes apply to sort processes that write to the index partition.

DEFAULT [node-name] default-attr

specifies a node name and an attribute value for all partitions on a specific node for

which another value is not explicitly specified. If you do not specify node-name,

SQL applies the DEFAULT statement to the node where the parallel index load is

initiated.

partition

specifies the name of the volume (including a node, if desired) that contains the

partition to which the attributes apply. For example:

$MYVOL

\NWREG.$SALES1

The default is the local node.

CPU ( num [, num ] ... )

is valid only if INDEX or BASETABLE is specified. processor specifies one or more

local or remote processors for the record generator or sort process. You can

specify multiple processors only for DEFAULT processors.

NOSCRATCHON ( scratchvol [, scratchvol ] ...)

is valid only if INDEX is specified. NOSCRATCHON specifies one or more volumes

to be excluded as overflow scratch volumes for the sort process. FastSort also

uses this list if you do not specify an initial set of scratch volumes (with the

SCRATCH option). The NOSCRATCHON option can be used as a DEFAULT

specification or for a specific partition. You cannot specify both NOSCRATCHON

and SCRATCHON.

If you specify NOSCRATCHON, SQL excludes $SYSTEM and TMF audit volumes

from the overflow set in addition to the volumes in your list. If SMF is installed on

your node, you can specify only physical volumes for NOSCRATCHON.

The scratchvol specification can include wild-card characters (* and ?).