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 overcome DEADLOCK

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
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    Post subject: How to overcome DEADLOCK
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: 464

PostPosted: Fri Jan 20, 2006 5:13 pm    Post subject: Re: How to overcome DEADLOCK
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: 680
Location: NJ

PostPosted: Fri Jan 20, 2006 7:43 pm    Post subject: Deadlock
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    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts Can a select query participate in a d... apvardhini DB2 1 Fri May 29, 2015 12:39 pm
No new posts Related to Deadlock issue sivareddy123 DB2 2 Fri Jan 30, 2015 3:59 pm
No new posts table scan can cause deadlock over RID? dejunzhu DB2 10 Fri Jul 04, 2014 8:36 am
No new posts Creating IDMS Deadlock seahawk789 IDMS/ADSO 1 Fri Apr 11, 2014 5:47 pm


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