Multiple choice technology mainframe

Sqlcode -911 means

  1. Timestamp mismatch

  2. Authorization failure

  3. Deadlock, rollback done

  4. Deadlock or time-out
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQLCODE -911 in DB2 indicates that a deadlock or timeout occurred, and the database system has automatically rolled back the transaction. This is a resource contention error where the transaction could not complete due to conflicts with other transactions or exceeded the wait timeout. Option C is correct because rollback is explicitly mentioned.

Keep practicing — related questions