On Chinese and Japanese locale Sybase IQ servers, 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
The workaround for this problem is:
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 workaround, certain strings in the .iqmsg files and the output of sp_iqmpxinfo, sp_iqstatistics, and sp_iqstatus will be in English instead of Chinese or Japanese.