SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-7
Specifying Configuration for Parallel Index Loading

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 processor 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 processors 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. For more information, see the Sample Configuration File on
page P-11.
LOCALONLY
directs SQL to run the parallel load operation and all associated sort processes on
the node where the operation was initiated. Use the LOCALONLY option to
{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 ] ... ) ]
attr is:
[ CPU ( num ) ]
[ NOSCRATCHON (scratchvol[, scratchvol]...) ]
[ NUMRECS ( number ) ]
[ PRI ( priority ) ]
[ PROGRAM ( file-name ) ]
[ SCRATCH ( scratchvol [, scratchvol ]...) ]
[ SCRATCHON (scratchvol [, scratchvol]...) ]
[ SWAP ( swapvol ) ]