IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 32

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

Answer options

• A. Concurrency may be improved
• B. Lock escalation will be prevented
• C. Query performance will be reduced
• D. The number of locks for the same workload will be reduced A

Correct answer:

Explanation

Changing the LOCKSIZE from TABLE to ROW allows for more granular locking, which can improve concurrency since multiple transactions can access different rows simultaneously. Lock escalation may still occur depending on the situation, and query performance generally tends to improve rather than decrease. Thus, the number of locks required for the same workload typically increases, not decreases.