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
 

 

Where to look for -911 deadlock details? URGENT

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

New User


Joined: 06 Jul 2005
Posts: 26
Location: Chennai

PostPosted: Thu Sep 01, 2005 4:24 pm    Post subject: Where to look for -911 deadlock details? URGENT
Reply with quote

Hi,

Please let me know where to look for the table details and jobs that were in deadlock (-911) etc.
I browsed through the MSTR log but no information was provided there.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Thu Sep 01, 2005 10:48 pm    Post subject: Re: Where to look for -911 deadlock details? URGENT
Reply with quote

Hi Nams,

Does that error message helps you to identify RESOURCE in contention.

Quote:
THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON <reason code>, TYPE OF RESOURCE <resource type>, AND RESOURCE NAME <resource name>


Try to have a look on this earlier post....May be you find something useful.
http://www.ibmmainframes.com/viewtopic.php?t=3765

Regards,

Priyesh.
Back to top
View user's profile Send private message
Anbudan

New User


Joined: 07 Sep 2005
Posts: 26
Location: Germany

PostPosted: Wed Sep 07, 2005 4:27 pm    Post subject:
Reply with quote

Hi Namasivayam

U can see the info on 'LOG' - which table is blocked and by whom.


Do u want more info?

explain ur question - in depth.



Anbudan
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
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Connect Direct details shankarm IBM Tools 2 Sat Feb 20, 2016 7:25 pm
This topic is locked: you cannot edit posts or make replies. Urgent Requirement in CTS Chennai. Mahi_e Mainframe Jobs 0 Wed Feb 17, 2016 3:52 pm


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