How to resolve -911 and -913

Kmr.deepakcs · New User Joined: 11 Oct 2013 Posts: 37 Location: India

every body, good morning....
As we know that -911 and -913 is dead lock and time out abend. but, can any body tell me how we resolve this issue, if we face these abends.......
suggestions required......thanks in advance

Nic Clouston · Posted: Sun Jan 05, 2014 7:56 pm

Doing a search on 'resolve deadlock' in this section of the forum I came up with 244 responses. One of them is this topic - have you read the other 243 looking for the answer?

dick scherrer · Posted: Mon Jan 06, 2014 7:40 pm

Hello,

These are quite often caused by improper design and/or code . . .

The correction is often changing how rows are accessed.

If there is only a pair of processes that cause these, schedult them to run at different times.

There are many, many possibilities and you should probably work with your dba to identify/correct the problem(s).

dbzTHEdinosauer · Posted: Mon Jan 13, 2014 7:38 pm

abend is abnormal termination of program.

a negative sql code can not cause an abend.

code in your program, either
forcing an abend due to a negative sql code
or
improperly handling data after receiving a negative sql code
will cause an abend.

when you call an apple
an orange,
it is difficult to determine if you have a problem with the juice or the sauce.