What is lock escalation?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is lock escalation?

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

(Continued on next question...)

Other Interview Questions

• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• On the create tablespace, what does the CLOSE parameter do?
• Explain transactions, commits and rollbacks in DB2?
• What can the SET option of the repair Utility accomplish?
• Once you create a view, where would information about the view be stored?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• Is it mandatory to use DCLGEN? If not, why would you use it at all ?
• What is a page?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What do you mean by NOT NULL WITH DEFUALT? When will you use it ?
• More...