HPE NonStop SQL/MX Error – 2102 This query could not be compiled with ‘MINIMUM’ optimization level. Suggestion: Retry with ‘MEDIUM’ optimization level.

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’