A System Administrator can configure:
The total number of locks available to processes on Adaptive Server
The size of the lock hash table and the number of spinlocks that protect the page/row lock hashtable, table lock hashtable, and address lock hash table
The server-wide lock timeout limit, and the lock timeout limit for distributed transactions
Lock promotion thresholds, server-wide, for a database or for particular tables
The number of locks available per engine and the number of locks transferred between the global free lock list and the engines
See the Adaptive Server System Administration Guide for information on these parameters.
