SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-10
Consideration—Parallel Index Loading
You can specify up to 32 volumes, limited by the line length (a maximum of 132
characters). The scratchvol specification can include wild-card characters
(* and ?).
You cannot specify both NOSCRATCHON and SCRATCHON. If you do not specify
either SCRATCHON or NOSCRATCHON, the sort processes consider using any
available volume except $SYSTEM and TMF audit trail volumes. If SMF is installed
on your node, you can specify only physical volumes for SCRATCHON.
SWAP ( swapvol [, swapvol ] ... )
is valid only if INDEX or BASETABLE is specified, and specifies the name of the
volume (including a node, if desired) on which to place the extended segment
swap file. For example:
$MYVOL
\NWREG.$SALES1
You can specify multiple swap volume names only for DEFAULT swap volumes.
Consideration—Parallel Index Loading
When the total number of table and index partitions approaches 750, parallel index
loading might terminate with one of these:
SQL error 1910, sort start error 10
SQL error 1928, record generator error 10.
If one of these errors occurs, increase the PFS space of the SQLCAT object and
license the new copy before reissuing your request.
To increase PFS size, use the BINDER product or specify the PFS run-time option.
You should increase the PFS size only when necessary. When you increase the size,
save an unmodified copy of SQLCAT.