FastSort Manual

Sorting From NonStop SQL/MP
FastSort Manual—429834-003
8-10
Configuring a CREATE INDEX Statement
same volume, processor and disk space contention problems can result. Use a
configuration file to specify a unique swap volume for each remote partition.
Using a Custom Configuration File
When you create an index and specify PARALLEL EXECUTION ON, you can use the
CONFIG option to specify a custom configuration file. The configuration file must be an
EDIT file. It can describe either a default configuration or an explicit configuration for
both record generator and sort processes. Default and explicit configurations are
discussed in Assigning Default and Explicit Values on page 8-14.
The values you specify in a configuration file override any values in a
=_SORT_DEFAULTS DEFINE. This subsection describes configuration file syntax and
contains a sample file.
Configuration File Syntax
The two types of statements in a configuration file are COMMENT and CREATE
INDEX. Keywords in the configuration file can be in uppercase, lowercase, or mixed-
case letters. The maximum length for a configuration file statement is 132 characters.
However, due to parser requirements, a line in a configuration file can be at most 80
characters long. Split statements longer than 80 characters into two lines of up to 80
characters each. In this case, insert an ampersand character (&) at the end of the first
line to specify that the lines make up a single statement.
Use the COMMENT statement to include descriptive notes in the file. SQL/MP ignores
lines that begin with the keyword COMMENT or the characters ==. The syntax for
COMMENT is as follows:
Caution. HP recommends that you use only a custom configuration file to configure a parallel
CREATE INDEX operation. If you omit the SCRATCH and SWAP attributes in your
configuration file and a =_SORT_DEFAULTS DEFINE contains fully qualified file names for
these attributes, processor and disk space contention problems can result.
{ COMMENT comment-text }
{ == comment-text }