FastSort Manual

Sorting From NonStop SQL/MP
FastSort Manual429834-003
8-8
Configuring a CREATE INDEX Statement
Because parallel processing uses more concurrent CPU cycles and disk processes
than serial processing, loading data in parallel could temporarily monopolize system
resources. Try to schedule other system tasks accordingly.
The default location of a RECGEN process is $SYSTEM.SYSnn.RECGEN, where nn
is a two-digit number assigned by HP. To specify a different location, use the
=_SQL_RECGEN_node DEFINE. You must have super ID authority on the specified
node to move a RECGEN process. For more information about this DEFINE, see
SQL/MP Reference Manual.
Configuring a CREATE INDEX Statement
When you create an index on a base table and do not specify PARALLEL EXECUTION
ON, you can use either the default configuration described in this subsection or a
=_SORT_DEFAULTS DEFINE. For more information on how to set up a
=_SORT_DEFAULTS DEFINE, see Configuring Your SQL/MP Sort Environment on
page 8-2. For detailed information about SORT DEFINEs and DEFINE attributes, see
Section 7, Using SORT and SUBSORT DEFINEs
.
Figure 8-1. Parallel Loading Data Into a Partitioned Index Table
Base Table Partitions
Index Table Partitions
Disk Process Block Mode Interface
SQLLOAD Routines
SQL Catalog
Manager
RECGEN RECGENRECGEN
SORTPROG SORTPROG SORTPROG
VST801.vsd