In this blog post, let’s learn about the error message “10048 IO to a scratch file failed because the free space threshold was reached on all available disks.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
10048 IO to a scratch file failed because the free space threshold was reached on all available disks.
Reason for the Error
The threshold, specified by the default SCRATCH_FREESPACE_THRESHOLD_PERCENT was reached on all available disks.
Solution
Reduce the threshold percentage and retry the query or specify a particular disk with adequate free space specifically for scratch use
