One transaction is trying to acquire a lock to modify a row in table A. Consider the database lock
timeout (locktimeout) parameter is set to 20 and that DB2 checks for deadlocks every 60 seconds.
What will happen to the transaction after 20 seconds waiting?
A.
DB2 will randomly select one application and rollback its current transaction to try to free up the
lock being helD.
B.
The application will rollback and the application will receive an error.
C.
The application will commit but the operation waiting for the lock is not completeD.
D.
The application will commit because after 20 seconds are passed the transaction acquires the
lock by force.
Explanation: