You can configure partitions to improve performance. The configuration parameters for partitions are:
number of open partitions – specifies the number of partitions that Adaptive Server can access simultaneously. The default value is 500.
partition spinlock ratio – specifies the number of spinlocks used to protect against concurrent access of open partitions. The default value is 10.
See Chapter 5, “Setting Configuration Parameters,” the System Administration Guide: Volume 1.
