Specifies the number of partitions in the IQ main and temp buffer
caches. Must be a power of 2. By default, allowed values are: 0 (default), 1, 2, 4, 8,
16, 32, 64, 128, 256. By default, SAP Sybase 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 SAP Sybase IQ server, and overrides the value set by the
Cache_Partitions database option.
-
Excludes
jConnect™ for JDBC™ system objects from the database. To use the jConnect
JDBC driver to access system catalog information, you need jConnect catalog
support (installed by default). When you specify this option, you can still
use JDBC, as long as you do not access system information. You can add
jConnect support at a later time using the ALTER DATABASE
statement.