Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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
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
References
priyesh.agrawal

Global Moderator


Joined: 28 Mar 2005
Posts: 1509
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: 27
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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1