Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error "-911" while running background job

Former Member
0 Kudos

Hi Experts,

We are getting the below runtime error while a background job is run.

SQL error "-911" when accessing table "DD02L".

Error Text of the Database: "SQL0911N The current transaction has been rolled

back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1"

The error is happening at a delete statement.

Please let me know what might be the reason of this error and how this can be resolved.

Thanks,

Jissa.

2 REPLIES 2

Former Member
0 Kudos

Hi,

The system is taking very long for processing delete statement.

can u send me ur code, so based on that i will give u some idea.

Ram.

Former Member
0 Kudos

it may be due to syntax error or else the given table may be locked

thanking you