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 hash table, table lock hash table, 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
