Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to resolve -911 and -913

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Kmr.deepakcs

New User


Joined: 11 Oct 2013
Posts: 37
Location: India

PostPosted: Sun Jan 05, 2014 5:27 pm    Post subject: How to resolve -911 and -913
Reply with quote

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
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1756
Location: UK

PostPosted: Sun Jan 05, 2014 7:56 pm    Post subject: Reply to: How to resolve -911 and -913
Reply with quote

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?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jan 06, 2014 7:40 pm    Post subject:
Reply with quote

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).
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Jan 13, 2014 7:38 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to resolve IMS DB status code FM Priyanka Boga IMS DB/DC 3 Fri Jun 10, 2016 1:54 pm
No new posts how to Resolve SQL Error Code -924 Rajesh3825 ABENDS & Debugging 2 Thu Dec 10, 2015 2:39 pm
No new posts How to resolve -532 pkmurali DB2 3 Thu Aug 06, 2015 10:03 pm
No new posts Resolve symbolics - other than starti... Shrinika Rajendran JCL & VSAM 4 Tue May 27, 2014 6:15 pm
No new posts SOC7 abend- How to resolve it sandeep kumar302 COBOL Programming 24 Wed Apr 30, 2014 5:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us