In this blog post, let’s learn about the error message “10151 operator cannot overflow data to disk, because no scratch disk satisfies the free space threshold.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
10151 operator cannot overflow data to disk, because no scratch disk satisfies the free space threshold.
Reason for the Error
The threshold specified by the default SCRATCH_FREESPACE_THRESHOLD_PERCENT was reached on all available scratch disks.
Solution
Either reduce the threshold percentage and retry the query, or specify a scratch disk with adequate free space
