NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
P-7
Specifying Configuration for Parallel Index Loading
•
Default pool of CPUs in which to run the record generators and another pool in
which to run the sort processes (CPU)
•
Default pool of volumes to use for the initial set of sort scratch files for the sort
processes (SCRATCH)
•
Default pool of volumes to use for overflow storage for the sort processes, if needed
(SCRATCHON)
•
Set of volumes to exclude from overflow storage (NOSCRATCHON)
•
Default pool of volumes to use for swap files for the record generators, and another
pool for swap files for the sort processes (SWAP)
In addition, you can specify any of these attributes for a specific partition. Thus,
CREATEINDEX specifies both default and explicit configuration values for record
generators and sort processes. The values you specify override any SQL defaults.
Use default values when you want SQL to choose from a set of values (such as scratch
volume names or CPU numbers) or to apply the same value to all processes (such as the
number of records or execution priority). Use explicit values when you want SQL to use
particular values for size limitation or performance reasons.
Default and explicit values are not mutually exclusive. You can set up user defaults to be
used in most cases and explicit values for one or two unusual partitions. For example,
you can explicitly specify sort scratch volumes but use a default configuration to specify
a pool of CPUs in which to run the sort processes. Or you might specify a default pool
of volumes to use as scratch files but specify particular scratch volumes for certain
partitions. (See the Sample Configuration File
on page P-11.)
{LOCALONLY}
CREATEINDEX{BASETABLE}{DEFAULT [node-name]default-attr}
{INDEX }{partition attr[,attr]... }
default-attr is:
[ CPU ( num [, num ] ... ) ]
[ NOSCRATCHON (scratchvol[, scratchvol]...) ]
[ NUMRECS ( number ) ]
[ PRI ( priority ) ]
[ PROGRAM ( file-name ) ]
[ SCRATCH ( scratchvol [, scratchvol ]...) ]
[ SCRATCHON (scratchvol [, scratchvol]...) ]
[ SWAP ( swapvol [, swapvol ] ... ) ]