IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to overcome DEADLOCK


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sagarika25

New User


Joined: 16 Jan 2006
Posts: 3

PostPosted: Fri Jan 20, 2006 4:39 pm
Reply with quote

Hi,

If i ll get error code -911 or -913 (that is both for deadlock), Then how come i overcome this problem???

For both the error code the solution is same or different?


Regards,
Sagarika
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463

PostPosted: Fri Jan 20, 2006 5:13 pm
Reply with quote

HI,

Quote:
If i ll get error code -911 or -913 (that is both for deadlock), Then how come i overcome this problem???

For both the error code the solution is same or different?


You can easily get answer of your question by just installing Abend Assist.

Regards
Rupesh
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Fri Jan 20, 2006 7:43 pm
Reply with quote

Hi sagarika25,
The thing is DB2 itself handles some Deadlock conditions. so -911 will rollback the situation since it itself cannot handle the situation. and if -913 prompts the low priority job can b killed mannaully. So Better Handle some Locking techniques such that to avoid the deadlock and place some checkpoint also. Hope it will help.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts DB2 deadlock DB2 2
No new posts -913/-911 Deadlock during UPDATE stat... DB2 5
No new posts Can a select query participate in a d... DB2 1
No new posts Related to Deadlock issue DB2 2
No new posts table scan can cause deadlock over RID? DB2 10
Search our Forums:

Back to Top