In this blog post, let’s learn about the error message “2102 This query could not be compiled with ‘MINIMUM’ optimization level. Suggestion: Retry with ‘MEDIUM’ optimization level.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2102 This query could not be compiled with ‘MINIMUM’ optimization level. Suggestion: Retry with ‘MEDIUM’ optimization level.
Reason for the Error
NonStop SQL/MX was unable to compile this query using the MINIMUM optimization level.
Solution
Resubmit the query with MEDIUM optimization level. Precede the statement with:
CONTROL QUERY DEFAULT OPTIMIZATION-LEVEL ‘MEDIUM’
