Number of locks

All processes in Adaptive Server share a pool of lock structures. As an initial estimate for configuring the number of locks, multiply the number of concurrent user connections you expect, plus the number of worker processes that you have configured, by 20.

The number of locks required by queries can vary widely. See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1. For information about how worker processes use memory, see “Worker processes”.