IBM Support

Online backup causes an SQL error 911 indicating a deadlock

Question & Answer


Question

This document explains that the error SQL0911N is defined as : "The current transaction has been rolled back because of a deadlock or timeout" and results in a backup failure. The document includes recommendations to check for deadlocks and to tune your database for backups.

[{"Product":{"code":"SSEPCD","label":"Content Manager OnDemand for Multiplatforms"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"2.2.1.10;2.2.1.5;2.2.1.6;2.2.1.7;2.2.1.8;2.2.1.9;7.1.0.0;7.1.0.1;7.1.0.2;7.1.0.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

18176;49R;000

Document Information

Modified date:
17 June 2018

UID

swg21031363