FastSort Manual

FastSort Error Messages
FastSort Manual—429834-003
B-27
Numeric List of Programmatic Messages

An increase of the maximum number of extents for the scratch file would cause the
file to exceed its maximum limit. FastSort also returns file system error 21
(ILLEGAL count SPECIFIED).

A file-system error (other than number 21) occurred when SORTPROG tried to
increase the number of extents for the scratch file.
Recovery. For the first error, create a partitioned scratch file large enough to hold all
of the records. For the second error, follow the recovery recommendations in the
Guardian Procedure Errors and Messages Manual for the file-system error number
returned with the FastSort error code.
Cause. Stated in the error message.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Check that the versions of RECGEN and SQLUTIL are compatible. If the
base table was in use when FastSort returned this error, ensure that the base table is
not in use and try to re-create the index. If this strategy fails to solve the problem,
generate and save a copy of your SAVEABEND file. Then contact your service
provider.
Cause. Stated in the error message.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. If the base table was in use when FastSort returned this error, ensure that
the base table is not in use and try again to create the index. If this strategy fails to
solve the problem, generate and save a copy of your SAVEABEND file. Then contact
your service provider.
Cause. The RECGEN process encountered an error while opening the SORTPROG
process. The file-system error number is included in this message.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Attempt to correct the file-system error condition and try again to create the
index. If this strategy fails to solve the problem, generate and save a copy of your
SAVEABEND file. Then contact your service provider.
Cause. Stated in the error message.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
134 INVALID RECGEN STARTUP MESSAGE.
135 INVALID RECGEN MESSAGE VERSION.
136 RECGEN SORTPROC_OPEN_ ERROR.
137 RECGEN INTERNAL ERROR: KEYS OUT OF ORDER.