IBM
C2090-320 · Question #86
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting…
The correct answer is D. Bind your application with CONCURRENTACCESSRESOLUTION. See the full explanation below for the reasoning.
Question
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?
Options
- ABind your application with ISOLATION(UR)
- BBind your application with ISOLATION(CS)
- CBind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
- DBind your application with CONCURRENTACCESSRESOLUTION
How the community answered
(30 responses)- A10% (3)
- B3% (1)
- C17% (5)
- D70% (21)
Community Discussion
No community discussion yet for this question.