Increase lock hash table size to improve query response time with Adaptive Server 15.5 Cluster Edition.
You may experience delayed query response time with Adaptive Server 15.5 Cluster Edition if the size of the lock hash table is insufficient. To avoid this, set the value of lock hashtable size using:
lock hashtable size = ( (number of locks * (4 + cluster redundancy level) ) + ( (total data cache size(in KB) / max database page size(in KB)) * (2 + cluster redundancy level) ) ) / 8
If the new value of lock hashtable size is more than the previously configured value, you must also increase the memory configuration of your Adaptive Server by 24 bytes for every byte of increase of lock hash table size.