---
title: "What is lock escalation?"  
description: "What is lock escalation?"  
author: "Anonymous User"  
published: 2011-03-28  
updated: 2020-09-22  
canonical: https://www.mindstick.com/interview/635/what-is-lock-escalation  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# What is lock escalation?

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.

## Answers

### Answer by Anonymous User

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.


---

Original Source: https://www.mindstick.com/interview/635/what-is-lock-escalation

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.