The query you have issued requires more kernel threads for the IQ Store.
Wait for another query to finish and release the threads it is using. Then resubmit your query.
Run the system stored procedure sp_iqconnection. The column IQThreads contains the number of IQ threads currently assigned to the connection. This column can help you determine which connections are using the most resources. Remember that some threads may be assigned but idle.
If the condition persists, you may need to restart
the server and specify more IQ threads. Use the -iqmt server
startup switch to increase the number of processing threads that Sybase IQ can
use. The default value of -iqmt is 60*numCPU+2*num_conn+1.
The total number of threads (-iqmt plus -gn) must
not exceed 4096 on 64-bit platforms, 1000 on IBM AIX 32-bit servers,
or 2048 on all other 32-bit platforms. This option is set automatically
to 450 by the start_asiq startup utility
on the IBM AIX platform.
