SQL/MX 2.x Messages Manual (G06.24+, H06.03+)
UPDATE STATISTICS and Executor Sort Messages 
(9200 through 10049)
HP NonStop SQL/MX Messages Manual—523730-004
11-11
Executor Sort Messages
SQL 10029 
Cause. An error occurred while calling a system level call.
Effect. The operation fails.
Recovery. See the Guardian Procedure Calls Reference Manual to diagnose and 
correct the problem, or contact your service provider.
SQL 10044 
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. See the Guardian Procedure Calls Reference Manual to diagnose and 
correct the problem, or contact your service provider.
SQL 10047 
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 
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.
10029 Sort failed while calling FILE_GETINFO_ with error 
number.
10044 IO to a scratch file did not complete and reported 
error number.
10047 Sort Error: Wrong length read.
10048 IO to a scratch file failed because the free space 
threshold was reached on all available disks.










