SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-50
Specifying Parallel Loading of Index Partitions
Using a Configuration File
You can specify the processors and other configuration options for both record
generators and sort processes in a configuration file. In a LOAD command, you can
specify a different configuration file for each partitioned index. The configuration
options you can specify include:
•
Default priority for the record generators and the sort processes (PRI)
•
Default object files for the record generators and the sort processes (PROGRAM)
•
Default number of records (NUMRECS)
•
Default pool of processors in which to run the record generators and another pool
in which to run the sort processes (processor)
•
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.
Example 5-3 on page 5-51 shows a sample configuration file: