On Sybase IQ servers that are set up for Chinese and Japanese locales, running sp_iqstatus returns an error similar to:
Could not execute statement. Syntax error near '2010' on line 1 SQLCODE=-131, ODBC 3 State="42000" Line 1, column 1
Workaround:
Stop the server.
For Chinese locales, remove dblgzh_iq11.dll from %IQDIR15%\bin32 (for 32-bit installations) or %IQDIR15%\bin64 (for 64-bit installations).
For Japanese locales, remove dblgja_iq11.dll from %IQDIR15%\bin32 (for 32-bit installations) or %IQDIR15%\bin64 (for 64-bit installations).
Restart the server.
After this procedure, certain strings in the .iqmsg files and the output of sp_iqmpxinfo, sp_iqstatistics, and sp_iqstatus are in English, instead of Chinese or Japanese.