FastSort Manual

Using SORT and SUBSORT DEFINEs
FastSort Manual—429834-003
7-2
Setting DEFINE Attributes
Use a single method to specify values for a subsort process. For subsort processes,
FastSort treats all parameter values as a single entity. After FastSort determines the
source of information for a subsort process, it ignores values from other sources.
Setting DEFINE Attributes
The table below lists the attributes for CLASS SORT and SUBSORT DEFINEs. These
attributes are described in this section and in Section 3, Using FastSort Commands.
Setting SORT DEFINE Attributes
The following SORT DEFINE attributes correspond to parameters for the FastSort
interactive commands in Section 3, Using FastSort Commands. Only the SCRATCH
attribute is required; all other SORT DEFINE attributes are optional. To set parameters
for SQL/MP, see Creating and Using the =_SORT_DEFAULTS DEFINE on page 7-13.
BLOCK size
specifies the block size, in bytes, for scratch files. Specify any multiple of 2048
bytes up to 56 KB, such as:
SET DEFINE BLOCK 28672
The number you specify must at least equal the size of the largest input record,
rounded up to the nearest even byte, plus 14 bytes overhead. For optimal
performance, specify 56 KB for local scratch files and 28 KB for remote scratch
files. The default is 56 KB.
CPU processor
specifies the processor (CPU) number for the SORTPROG process. The range is
0 through 15, such as:
SET DEFINE CPU 2
The default is the CPU where the process that starts SORTPROG is running.
Priority Value Type Specified By
1 User-specified A SORT or SUBSORT DEFINE
2 User parameter A FastSort interactive parameter or system procedure call
3 Default The =_SORT_DEFAULTS DEFINE
Class Attributes
SORT BLOCK, CPU, CPUS, MODE, NOSCRATCHON, NOTCPUS, PRI, PROGRAM,
SCRATCH, SCRATCHON, SEGMENT, SUBSORTS, SWAP, VLM
SUBSORT BLOCK, CPU, PRI, PROGRAM, SCRATCH, SEGMENT, SWAP