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

How to solve dead lock


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 290
Location: Basel, Switzerland

PostPosted: Tue Mar 14, 2006 4:50 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Lock Escalation DB2 3
No new posts how to solve this power failure shutd... ABENDS & Debugging 5
No new posts Any idea about how to solve 3022 aben... IMS DB/DC 3
No new posts How to put exclusive lock on a file i... JCL & VSAM 4
No new posts dead lock while updating the DB2 table DB2 7
Search our Forums:

Back to Top