FastSort Manual

Optimizing Sort Performance
FastSort Manual—429834-003
9-17
Automating DEFINEs
configures the =_SORT_DEFAULTS DEFINE for a parallel sort operation. SCRATCH1
specifies only volume names for scratch and swap files, as follows:
SET DEFINE SCRATCH $DATA2
SET DEFINE SWAP $SPARE2
You could use the SCRATCH1 configuration if the SQL optimizer chooses a parallel
plan for a query that invokes FastSort.
A second command file, SCRATCH2, configures scratch and swap space for loading
data from a large SQL/MP table. It directs FastSort to use a 3 GB partitioned scratch
file for the load operation, as follows:
SET DEFINE SCRATCH $SPARE2.SCRATCH.PART
SET DEFINE SWAP $SPARE1
To shift from the first configuration to the second, change the nested file name in the
top-level command file.
Using the SAVE Command
To preserve the DEFINE attributes of your current SQLCI session, use the SAVE
command before you exit SQLCI. This command automatically preserves SQLCI
session attributes as commands in a file. For more information about the SAVE
command including syntax, see SQL/MP Reference Manual.