Escalation of Locks
Lock escalation can occur under either of the following conditions:
• The number of logical locks held on a specific table exceeds the "maxlocks" value for the table
• The number of logical locks held by the transaction exceeds the configured "per_tx_limit"
If either of these conditions occurs, lock escalation:
• Acquires an appropriate S or X table-level lock on the table whose lock request exceeded the limit
• Releases all other locks associated with the table (PAGE, ROW, VALUE)
• Continues the transaction with a lock level of TABLE on the affected table
Note: The issuing of lock escalation messages is configurable.