Scratch file I/O messages

SQL 10101

10101 operator failed to create a scratch file. FILE_CREATE_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join;

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator was unable to create a scratch file.

Effect

The operation fails.

Recovery

Contact your service provider to diagnose the cause of the FILE_CREATE_ returned error and correct the problem.

SQL 10102

10102 operator failed to open a scratch file. FILE_OPEN_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example:

merge join.

number is a SQL/MX platform internal procedure-error number.

Cause

The query operator was unable to open a scratch file.

Effect

The operation fails.

Recovery

None. This is an internal error. Contact your service provider.

SQL 10103

10103 operator failed to close a scratch file. FILE_CLOSE_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is a SQL/MX platform internal procedure-error number.

Cause

The query operator was unable to close a scratch file.

Effect

The operation fails.

Recovery

Do not attempt recovery. Contact your service provider.

SQL 10104

10104 operator scratch file write failed. WRITEX returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator was unable to write to a scratch file.

Effect

The operation fails.

Recovery

Contact your service provider to diagnose the cause of the WRITEX returned error and correct the problem.

SQL 10105

10105 operator scratch file read failed. READX returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator was unable to read from a scratch file.

Effect

The operation fails.

Recovery

Contact your service provider to diagnose the cause of the READX returned error and correct the problem.

SQL 10110

10110 operator failed to alter a scratch file. SETMODE returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator was unable to alter a scratch file's attributes.

Effect

The operation fails.

Recovery

Contact your service provider to diagnose the cause of the SETMODE returned error and correct the problem.

SQL 10111

10111 operator could not wait for a scratch file I/O to complete. AWAITIOX returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator failed to complete a scratch file asynchronous I/O operation.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10112

10112 operator failed to set the current position in a scratch file. FILE_SETPOSITION_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator failed to set the current position in a scratch file.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10113

10113 operator could not get the last error for a scratch file. FILE_GETINFO_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The query operator failed to get the last error for a scratch file.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10114

10114 operator could not read the EOF position for a scratch file. FILE_GETINFOLIST_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

An invocation of FILE_GETINFOLIST_ failed.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10115

10115 operator was unable to obtain disk volume free space information. FILE_GETINFOLISTBYNAME_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

An invocation of FILE_GETINFOLISTBYNAME_ failed.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10116

10116 operator failed to create a disk pool. PROCESSHANDLE_GETMINE_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

An invocation of PROCESSHANDLE_GETMINE_ failed.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10117

10117 operator failed to create a disk pool. PROCESSHANDLE_DECOMPOSE_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

The operation fails.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10118

10118 operator encountered an error while searching for a scratch disk. FILENAME_FINDSTART_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

An invocation of FILENAME_FINDSTART_ failed.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10119

10119 operator encountered an error while searching for a scratch disk. FILENAME_FINDNEXT_ returned error number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

number is an SQL/MX platform internal procedure-error number.

Cause

An invocation of FILENAME_FINDNEXT_ failed.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10130

10130 Scratch I/O Error: CreateDir failed.

Cause

An error occurred while calling a system level call.

Effect

The operation fails.

Recovery

No recovery possible. Contact your service provider.

SQL 10131

10131 Scratch I/O Error: CreateFile failed.

Cause

An error occurred while calling a system level call.

Effect

The operation fails.

Recovery

No recovery possible. Contact your service provider.

SQL 10132

10132 Scratch I/O 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 10133

10133 Scratch I/O 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 10134

10134 Scratch I/O Error: WriteFile failed.

Cause

An error occurred while calling a system level call.

Effect

The operation fails.

Recovery

No recovery possible. Contact your service provider.

SQL 10135

10135 Scratch I/O 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 10136

10136 Scratch I/O 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 10137

10137 Scratch I/O 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 10138

10138 Scratch I/O 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 10139

10139 Scratch I/O 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 10140

10140 Scratch I/O 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 10141

10141 Scratch I/O Error: GetDiskFreeSpace failed.

Cause

An error occurred while calling a system level call.

Effect

The operation fails.

Recovery

No recovery possible. Contact your service provider.

SQL 10150

10150 operator failed to find an appropriate disk for overflow data.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

Cause

The query operator could not find an appropriate scratch disk.

Effect

The operation fails.

Recovery

None. Ensure that the disks for scratch file use are appropriate and have enough space. These disks are not suitable: optical disks, phantom disks, and Storage Management Foundation (SMF) virtual disks.

SQL 10151

10151 operator cannot overflow data to disk, because no scratch disk satisfies the free space threshold.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

Cause

The threshold specified by the default SCRATCH_FREESPACE_THRESHOLD_PERCENT was reached on all available scratch disks.

Effect

The operation fails.

Recovery

Either reduce the threshold percentage and retry the query, or specify a scratch disk with adequate free space.

SQL 10152

10152 operator attempted to read data using an invalid block number.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

Cause

The query operator attempted to read a nonexistent block of data from a scratch file.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.

SQL 10153

10153 operator attempted to read data using a block number that was not mapped to a scratch file.

Where,

operator is the SQL/MX query operator that encountered the error; for example: merge join.

Cause

The mapping of data blocks to scratch files is incomplete.

Effect

The operation fails.

Recovery

None. This is an internal error. Do not attempt recovery. Contact your service provider.