Sets the number of IQ main and temp buffer cache partitions.
-iqpartition num
Specifies the number of partitions in the IQ main and temp buffer caches. Must be a power of 2. Allowed values are: 0 (default), 1, 2, 4, 8, 16, 32, 64, 128, 256. By default, IQ computes the number of partitions automatically as number_of_cpus/8, rounded to the nearest power of 2, up to a maximum of 64. You may be able to improve performance by adjusting the number of cache partitions. The -iqpartition switch sets this value for an IQ server, and overrides the value set by the Cache_Partitions database option.
See Reference: Statements and Options> Database Options > Alphabetical List of Options > CACHE_PARTITIONS Option.
See System Administration Guide: Volume 1 > Transactions and Versioning > Tools for Managing Locks.