IBM DB2 Question:

How does DB2 determine what lock-size to use?

Tweet Share WhatsApp

Answer:

1. Based on the lock-size given while creating the tablespace
2. Programmer can direct the DB2 what lock-size to use
3. If lock-size ANY is specified, DB2 usually chooses a lock-size of PAGE

Download IBM DB2 PDF Read All 32 IBM DB2 Questions
Previous QuestionNext Question
What are the disadvantages of PAGE level lock?What are delete-connected tables?