sp_iqstatus returns error on Chinese and Japanese locale installations [CR 622928]

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:

  1. 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
    
  2. 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.