FastSort Manual

Using SORT and SUBSORT DEFINEs
FastSort Manual—429834-003
7-5
Setting SUBSORT DEFINE Attributes
SUBSORTS ( DEFINE-name [, DEFINE-name ]... )
specifies a list of DEFINE names for subsort processes. Separate the DEFINE
names with commas and enclose them in parentheses, such as:
SET DEFINE SUBSORTS (=subsorta, =subsortb, =subsortc)
FastSort checks DEFINE names for validity at run time.
SWAP file-name
specifies the name of a swap file to use in an extended memory data segment.
The swap file you specify must be a disk file or volume on the local node, such as:
SET DEFINE SWAP $data.fastsort.swapfile
If the file already exists, it must be unstructured. The default location for the swap
file depends on the location of the scratch file. If the scratch file is local, the swap
file is on the scratch volume. For remote scratch files, the default is the volume
where the program file is running.
VLM { ON | OFF }
specifies whether to use additional extended memory during a sort run. For
example:
SET DEFINE VLM ON
makes extra memory available. FastSort uses the additional extended memory to
either complete the sort in a single pass or store partial information until the sort is
complete. When VLM is ON, FastSort uses up to 127.5 MB of extended memory, if
available. The default value is OFF.
Setting SUBSORT DEFINE Attributes
The SUBSORT DEFINE attributes set values for a subsort process that you name in
the SUBSORT attribute of a SORT DEFINE. SUBSORT DEFINE attributes correspond
to the parameters of the SUBSORT command, which are described in Section 3, Using
FastSort Commands. To set parameters for parallel SQL/MP load operations, see
Loading Data
on page 8-7.
CPU processor
specifies the number of the processor (CPU) in which to run the subsort process,
such as:
SET DEFINE CPU 3
The range is 0 through 15. The default is the processor in which the primary disk
process for the initial scratch volume is running.