If you access multiple databases on a single Sybase IQ or Adaptive Server 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 Sybase IQ Reference Manual, as you do not normally need
to set it for an IQ database. For any purpose other than the one
described here, if you need to increase the number of threads you set
the -iqmt switch, which controls the
number of threads for IQ Store operations.
