Show TOC

Lock List EscalationsLocate this document in the navigation structure


Lock list escalations: <count>


The number of row locks in a table is too high. The database system attempts to convert the row locks into a table lock.

User Response

You can specify the maximum number of possible row locks in the lock list in the general database parameter MaxSQLLocks. The database system attempts to convert the row lock to a table lock if a task holds more than 0,1*MaxSQLLocks row locks in a table. If too many escalations occur, increase the parameter value.

Whether escalations lead to problems depends strongly on the application in question. If escalations occur, check the application to see whether you can split any change transactions that lock many rows into several individual transactions.