FastSort Manual

Optimizing Sort Performance
FastSort Manual—429834-003
9-14
Managing Sort Failures
$SYSTEM.SYS01.SORTPROG
Binder timestamp: 10NOV94 10:12:17
Version procedure: T9620D30^31OCT94^AAU^31OCT94
Target CPU: TNS, TNS/R
Compare the information VPROC returns with version information in the softdocs
shipped with your NonStop software. These documents contain product and RVU
numbers for the specific product they describe. Softdocs also contain software
compatibility information. If you do not have access to these documents, contact your
system manager.
To determine your operating system version, check the $SYSTEM.SYSnn. CONFLIST
file. This file is generated by SYSGEN when you install a version of the NonStop
Kernel. The first page of the file contains operating system RVU and compatibility
information. If you do not have read access to this file, contact your system manager.
To determine the version of SQL/MP on your node, execute the following command
from within SQLCI:
GET VERSION OF SYSTEM;
For more information about the GET VERSION statement, see SQL/MP Reference
Manual.
Saving Failure Information
If a sort fails and you cannot quickly identify the cause, you should save information
about the sort process. This information will help diagnose the reason for failure if you
have to contact your service provider.
You can automatically capture information about any failed process in a disk file. If a
sort process terminates abnormally, this file contains valuable information about
conditions at the point of termination. To automatically create a save file, you use the
Binder utility to turn SAVEABEND ON.
To start the Binder utility, type
BIND
at a TACL prompt. The syntax for creating a SAVEABEND file for a SORTPROG or
RECGEN process at the Binder prompt is:
CHANGE SAVEABEND ON IN [ SORTPROG | RECGEN ]
To turn on SAVEABEND, you must have permission to write to the object file. For
FastSort, the object file is SORTPROG or RECGEN. If you do not have write
permission to these files, contact your system manager.
You must direct the operating system to create a save file before a failure occurs. If
SAVEABEND is not already set to ON on your local node when a sort fails, you must