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 solve dead lock

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

New User


Joined: 12 Dec 2005
Posts: 7
Location: trivandrum

PostPosted: Tue Mar 14, 2006 4:37 pm    Post subject: How to solve dead lock
Reply with quote

Hi,

If dead lock occurs how to resolve it? How can we know which transaction is using same table? can u please give me solution for the same.
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 288
Location: Basel, Switzerland

PostPosted: Tue Mar 14, 2006 4:50 pm    Post subject:
Reply with quote

hy s.anand,

look at the db2 logs to find out on which object
the deadlock occurred, then find out, who was
already on this object at the same time.

other possibility, you control it with the db2
performance monitor, or any other monitor
you have at your site...
just make sure to enable the history feature...

martin9
Back to top
View user's profile Send private message
anandss6

New User


Joined: 12 Dec 2005
Posts: 7
Location: trivandrum

PostPosted: Wed Mar 22, 2006 10:56 pm    Post subject: Re: How to solve dead lock
Reply with quote

Thanks martin
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 put exclusive lock on a file i... sudarshan.srivathsav JCL & VSAM 4 Fri Jun 05, 2015 10:36 pm
No new posts dead lock while updating the DB2 table abdulrafi DB2 7 Tue Oct 22, 2013 7:02 pm
No new posts DB2: How to solve -805 DB2 Sql code trushant.w Mainframe Interview Questions 3 Fri Oct 04, 2013 3:47 pm
No new posts Dead lock in DB2 - CICS programs Pandora-Box CICS 8 Fri Sep 13, 2013 3:47 pm
No new posts IRLM Lock Compatibility Amit.Agarwal IMS DB/DC 0 Sat Mar 30, 2013 5:15 pm


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