Sybase IQ offers the following options to help you manage thread usage.
To set the maximum number of threads available for Sybase IQ use, set the server startup option -iqmt. The default value is calculated from the number of connections and the number of CPUs and is usually adequate.
To set the stack size of the internal execution threads in the server, set the server startup option -iqtss. The default value is generally sufficient, but may be increased if complex queries return an error indicating that the depth of the stack exceeded this limit. For details about -iqmt and -iqtss, see Chapter 1, “Running the Database Server,” Sybase IQ Utility Guide.
To set the maximum number of threads a single user will use, issue the command SET OPTION MAX_IQ_THREADS_PER_CONNECTION. This can be used to control the amount of resources a particular operation consumes. For example, the DBA can set this option before issuing an INSERT or LOAD command.
