COBOL · DB2 SQLCODE

SQLCODE -911

What does SQLCODE -911 mean in COBOL?

Deadlock or timeout, rolled back. The current unit of work was rolled back after a deadlock or a lock wait timeout with another process.

SQLCODE -911DB2 for z/OS · Db2 (embedded SQL in COBOL)

Condition

Deadlock or timeout, rolled back. The current unit of work was rolled back after a deadlock or a lock wait timeout with another process.

Fix

Check for two processes updating rows in a different order, which is the classic deadlock pattern, and confirm transaction scope is as short as possible so locks are not held longer than necessary.

Pending source verification. Not yet checked against official documentation.

Related db2 sqlcode