Multi-CPU or hyperthreaded machines may experience issues.
SAP Sybase IQ runs most efficiently when it knows how many physical CPUs are available to it. On a machine with hyperthreads turned on, or where SAP Sybase IQ cannot access all of the available CPUs, SAP Sybase IQ creates too many threads and run less efficiently than it should.
Start the server with -iqnumbercpus set to the number of CPUs available to SAP Sybase IQ, overriding the physical number of CPUs.
For details on start_iq database options, see the Utility Guide.