SQL/MP Messages Manual

FastSort Messages
HP NonStop SQL/MP Messages Manual—427720-006
21-8
FastSort 30
Cause. SORTPROG could not write to a scratch file, either because you
underestimated the number of input records or because of a disk process or data flow
problem.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Ensure that sufficient scratch space exists for the sort. SORTPROG might
require more overflow scratch space. For more information on scratch files, refer to the
FastSort Manual. If you are unable to estimate the number of input records, create a
scratch file and specify that file name in the SORT DEFINE SCRATCH attribute.
Also check the recovery recommendations in the Guardian Procedure Errors and
Messages Manual for the file-system error number returned with this FastSort error
code.
FastSort 31
Cause. SORTPROG could not read an input file.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Follow recovery recommendations in the Guardian Procedure Errors and
Messages Manual for the operating system error code returned with this FastSort error
code.
FastSort 32
Cause. SORTPROG could not read a scratch file.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Follow recovery recommendations in the Guardian Procedure Errors and
Messages Manual for the operating system error code returned with this FastSort error
code.
30 A write has failed to a SCRATCH file.
31 A read has failed from the FROM file.
32 A read has failed from a SCRATCH file.