FastSort Manual

Optimizing Sort Performance
FastSort Manual—429834-003
9-15
Automating FastSort Tasks
first turn on SAVEABEND and then duplicate the failure in order to save information in
a save file.
To exit the Binder utility, type
EXIT
The save file contains information about the process environment at the time of
termination, including:

Names of all open files

A copy of the data space at the time the process terminated

Name of the process and a timestamp for the time of termination
The default save file location is the location of the specified object file. The save file
name is always of the format ZZSAnnnn.
You can also use the Inspect SAVE and PR commands to save the environment of a
failed process. Like the Binder utility, you must direct Inspect to save failure information
before a failure occurs. For more information about these commands, see Inspect
Manual.
Automating FastSort Tasks
One way to automate FastSort tasks is to use a command file. A command file, also
sometimes called an OBEY file, is an EDIT file that contains a series of commands.
When you execute the file, commands in the file are automatically executed. Use a
command file to automate tasks that:

Are repetitive

Require many commands and few decisions

Can cause serious problems if not properly executed
For example, you might regularly perform these tasks:

Load data from one SQL/MP table into another

Execute a query that causes a sort-merge join of a large SQL/MP table
The load and query operations each require an SQL statement and a
=_SORT_DEFAULTS DEFINE. To reduce execution time, you can specify the
commands required for each task in an EDIT file. Then execute the file when you need
to perform the task. To automate configuration, you could set up a separate
=_SORT_DEFAULTS DEFINE for each task. Then either enable the appropriate
DEFINE in the command file or specify DEFINE commands directly in the file.
Note. Turning SAVEABEND ON also sets the Binder INSPECT option to ON. For more
information about the Binder CHANGE command, see Binder Manual.