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:
Run these commands:
For Chinese locales:
% cd $IQDIR15/res % rm dblgzh_iq11_eucgb.res % rm dblgzh_iq11_cp936.res
For Japanese locales:
% cd $IQDIR15/res % rm dblgja_iq11_eucjis.res % rm dblgja_iq11_sjis.res
Restart Sybase IQ.
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.