In this blog post, let’s learn about the error message “10150 operator failed to find an appropriate disk for overflow data.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
10150 operator failed to find an appropriate disk for overflow data.
Reason for the Error
The query operator could not find an appropriate scratch disk.
Solution
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
