Informix Error -11417: Selected locale/codeset will result in performance degradation.
Cause and resolution
Selected locale/codeset will result in performance degradation.
The selected locale/codeset will result in performance degradation. For optimum performance, use the same client and database locale.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11417 is a performance advisory the CLI driver raises when the client and database locale/ codeset don't match — per the official guidance.
- A client locale/codeset that differs from the database's, per the official guidance — the direct, only cause; mismatched locales force extra conversion work.
Solutions / Resolution
- Use the same client and database locale for optimum performance, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a client/database locale mismatch.
Diagnostic Checks
- Check the client's configured locale/codeset against the database's, and align them if performance is a concern.
Related Errors / Related Topics
- -11418 — "Locales not found." A related locale-configuration issue, about a locale being entirely missing on the client rather than merely mismatched.
The selected client locale/codeset differs from the database's, degrading performance — use matching locales.