FastSort Manual

Sorting From NonStop SQL/MP
FastSort Manual—429834-003
8-3
Setting Up a =_SORT_DEFAULTS DEFINE
You can create or modify a =_SORT_DEFAULTS DEFINE directly from your SQLCI
prompt. The syntax for creating a =_SORT_DEFAULTS DEFINE is:
All TACL DEFINE commands, such as SET DEFINE and ALTER DEFINE, are valid
for the =_SORT_DEFAULTS DEFINE. You can also name and set any SORT or
SUBSORT DEFINE attribute in a =_SORT_DEFAULTS DEFINE.
You must specify CLASS SORT for the =_SORT_DEFAULTS DEFINE. You can
specify CLASS SORT either in the ADD DEFINE command or through the working
attribute set. To learn how to use DEFINE commands and SORT and SUBSORT
DEFINE attributes, see Section 7, Using SORT and SUBSORT DEFINEs.
The example below creates a =_SORT_DEFAULTS DEFINE and specifies values for
the SCRATCH, SWAP, CPU, AND PRI attributes:
ADD DEFINE =_SORT_DEFAULTS, CLASS SORT,
SCRATCH $DATA, SWAP $DATA2, CPU 3, PRI 100
At run time, if the scratch and swap files you specify in a =_SORT_DEFAULTS
DEFINE do not exist, FastSort automatically creates these files and sets
MAXEXTENTS to 160. If you manually create scratch and swap files, size them
according to the number of records to sort and extended memory segment size,
respectively. For more information about scratch and swap files, see Section 9,
Optimizing Sort Performance.
ADD DEFINE =_SORT_DEFAULTS, CLASS SORT
[, BLOCK block-size ]
[, CPU cpu-number ]
[, CPUS subsort-cpu-list ]
[, MODE mode-type ]
[, NOSCRATCHON ( volume-list ) ]
[, NOTCPUS cpu-list-not-subsort ]
[, PRI process-priority ]
[, PROGRAM file ]
[, SCRATCH file ]
[, SCRATCHON ( volume-list ) ]
[, SEGMENT extended-segment-size ]
[, SUBSORTS define-list ]
[, SWAP file-name ]
[, VLM { ON | OFF } ]