How can you accomplish this?

Posted by: Pdfprep Category: C2090-320 Tags: , ,

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?
A . Bind your application with ISOLATION(UR)
B . Bind your application with ISOLATION(CS)
C . Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
D . Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

Answer: D

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/ db2z_accesscommitteddata.html

Leave a Reply

Your email address will not be published.