IBM DB2 Question:
How does DB2 determine what lock-size to use?
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
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
| Previous Question | Next Question |
| What are the disadvantages of PAGE level lock? | What are delete-connected tables? |