Executor sort messages
SQL 10003
10003 Sort unexpectedly encountered an EOF during a read operation.
Cause
This error occurs when a scratch file read operation unexpectedly reaches an EOF.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10004
10004 Sort failed while generating intermediate runs with sort error value1 and system error value2.
Cause
This error occurs when a scratch file operation fails, causing the generation of intermediate runs to fail during the merge phase of a sort. The sort error would indicate any low-level sort error and the system error, if any, would indicate the low-level system error. If the cause is only a sort error, the system error may be 0.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10005
10005 Sort encountered an unexpected error.
Cause
An unknown sort error occurred.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10006
10006 A previous IO to a scratch file failed.
Cause
A previous I/O failed during a nowaited scratch file I/O operation.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10007
10007 Sort failed while writing to a scratch file with error system error.
Cause
An I/O error occurred during a scratch file I/O operation.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10008
10008 Invalid sort algorithm selected.
Cause
The caller of sort specified an invalid sort algorithm.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10010
10010 Sort run number is invalid.
Cause
The scratch run on the disk does not belong to any scratch block on the disk.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10011
10011 Sort failed while reading a scratch file with error system error.
Cause
An I/O error occurred during a scratch file I/O operation.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10012
10012 Sort failed during overflow with an invalid block number: number.
Cause
The caller specified a block number that is out of range.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10013
10013 Sort could not find any appropriate disks for overflow.
Cause
The available disks on the system are not suitable for scratch usage.
Effect
The operation fails.
Recovery
Ensure that there are appropriate disks with enough space for scratch file use. Disks such as optical disks, phantom disks, and Storage Management Foundation (SMF) virtual disks are not considered suitable. See the SQL/MX Reference Manual for more information on how to influence the placement of scratch files.
SQL 10014
10014 Sort ran out of memory while allocating an internal data structure.
Cause
An internal data structure could not be allocated because of an out of memory condition.
Effect
The operation fails.
Recovery
None. This is an internal error. Contact your service provider.
SQL 10015
10015 Sort failed while calling PROCESSHANDLE_GETMINE_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10016
10016 Sort failed while calling PROCESSHANDLE_DECOMPOSE_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10017
10017 Sort failed while calling DEVICE_GETINFOBYLDEV_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10018
10018 Sort failed while calling FILENAME_FILESTART_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10019
10019 Sort failed while calling FILENAME_FILENEXT_ with error error-number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10020
10020 Sort failed while calling FILENAME_FINDFINISH_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10021
10021 Sort failed while calling FILE_GETINFOLISTBYNAME_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10022
10022 Sort failed while calling FILE_CREATE with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10023
10023 Sort failed while calling FILE_OPEN_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10024
10024 Sort failed while calling SETMODE_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10025
10025 Sort Error: FileClose failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10026
10026 I/O to a scratch file failed while calling AWAITIOX with error number.
Cause
An I/O to a scratch file failed with a low-level system error.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10027
10027 Sort failed while calling FILE_GETINFOLIST with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10028
10028 Sort failed while calling POSITION with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10029
10029 Sort failed while calling FILE_GETINFO_ with error number.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10030
10030 Sort Error: GetTempPath error :path name too long.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
Contact your service provider.
SQL 10031
10031 Sort Error: GetVolumeInformation failed, check root path.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10032
10032 Sort Error: GetDiskFreeSpace failed, check rootPath Name_.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10033
10033 Sort Error: GetTempFileName failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10034
10034 Sort Error: Create File failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10035
10035 Sort Error: CreateEvent failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10036
10036 Sort Error: CloseHandle failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10037
10037 Sort Error: SleepEx failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10038
10038 Sort Error: WaitForSingleObject failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10039
10039 Sort Error: Sort Error:ResetEvent failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10040
10040 Sort Error: SetFilePointer failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10041
10041 Sort Error: _chdir failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10042
10042 Sort Error: Create Directory failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10043
10043 Sort Error: Write Failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10044
10044 IO to a scratch file did not complete and reported error number.
Cause
After several calls to the completion routine, the IO to a scratch file did not complete and returned a low level system error.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10045
10045 Sort Error: WaitForMultipleObjects failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10046
10046 Sort Error: GetOverlappedResult failed.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.
SQL 10047
10047 Sort Error: Wrong length read.
Cause
The length of the data returned was not what was expected.
Effect
The operation fails.
Recovery
None. This is an internal error. Contact your service provider.
SQL 10048
10048 IO to a scratch file failed because the free space threshold was reached on all available disks.
Cause
The threshold, specified by the default SCRATCH_FREESPACE_THRESHOLD_PERCENT was reached on all available disks.
Effect
The operation fails.
Recovery
Reduce the threshold percentage and retry the query or specify a particular disk with adequate free space specifically for scratch use.
SQL 10049
10049 The block number was not found in any scratch file.
Cause
The I/O operation failed because an expected scratch file that was created was not found.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 10051
10051 Io to scratch file failed while calling CONTROL with error errornumber.
Cause
An error occurred while calling a system level call.
Effect
The operation fails.
Recovery
No recovery possible. Contact your service provider.