SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Executor Sort and Scratch File I/O Messages (10000
through 10199)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
12-20
Scratch File I/O Messages
SQL 10150
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
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
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.
10150 operator failed to find an appropriate disk for
overflow data.
10151 operator cannot overflow data to disk, because no
scratch disk satisfies the free space threshold.
10152 operator attempted to read data using an invalid block
number.