PL/I · DB2 SQLCODE
What does SQLCODE -911: Unit of Work Rolled Back Due to Deadlock or Timeout mean in PL/I?
The PL/I program's transaction was either chosen as the deadlock victim or it waited past the IRLM timeout threshold for a lock another unit of work held, and DB2 rolled back everything since the last COMMIT.
The PL/I program's transaction was either chosen as the deadlock victim or it waited past the IRLM timeout threshold for a lock another unit of work held, and DB2 rolled back everything since the last COMMIT.
Add more frequent COMMITs to shrink the program's lock footprint and exposure window, check SQLERRD(3) (00C90088 for deadlock, 00C9008E for timeout) to know which occurred, and consider adjusting isolation level or access order if timeouts recur under normal load.