If you access multiple databases on a single Sybase IQ or SQL Anywhere server, you may need to increase the number of threads used by the database server using the -gx command-line switch. By default, this switch is set to one more than the number of CPUs on the machine.
You must have enough threads available to support the individual tasks that are being run by a query. Failure to provide the number of required tasks can lead to a query becoming blocked on itself.
The -gx switch is not documented
in the Utility Guide, as you do not normally need
to set it for an IQ database. For any purpose other than the one described
here, to increase the number of threads, set the -iqmt switch,
which controls the number of threads for IQ store operations.
