Sybase IQ stops processing or stops responding

Possible causes

The following are the two most common causes of server unresponsiveness, which can be detected by looking in the Sybase IQ message file:

Action

If your server seems to be prone to unresponsiveness, either while processing or during shutdown, use the start_asiq command line option -z and the Sybase IQ database option QUERY_PLAN = 'ON' to log useful information in the Sybase IQ message (.iqmsg) and server log (.srvlog) files. In addition to logging this information, there are other steps you can take to determine the cause of the problem: