SQL/MP Messages Manual

FastSort Messages
HP NonStop SQL/MP Messages Manual427720-006
21-17
FastSort 64
Cause. FastSort could not allocate an extended memory segment for a sort or subsort
process.
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. If operating system error 43 is returned, try specifying a different swap value
using the SORT DEFINE SWAP attribute.
FastSort 65
Cause. The sort key field specified for a key-sequenced file is not the same as the
file's primary key field. Another possible cause is that the data type of the sort key field
is not UNSIGNED.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Make sure the sort key field and the primary key field are the same. When
the type of the output file is key-sequenced, make sure the type of the sort key field is
UNSIGNED.
FastSort 66
Cause. The data slack value in the call to SORTMERGESTART was outside the limits
for the value.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Change the dslack parameter. For more information on the description of
dslack under the SORTMERGESTART procedure, refer to the FastSort Manual.
64 Extended segment cannot be allocated.
65 Invalid key for key-sequenced file.
66 Invalid data SLACK specified.