In this blog post, let’s learn about the error message “10013 Sort could not find any appropriate disks for overflow.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
10013 Sort could not find any appropriate disks for overflow.
Reason for the Error
The available disks on the system are not suitable for scratch usage.
Solution
Ensure that there are appropriate disks with enough space for scratch file use. Disks such as optical disks, phantom disks, and Storage Management Foundation (SMF) virtual disks are not considered suitable. See the SQL/MX Reference Manual for more information on how to influence the placement of scratch files
