|
View previous topic :: View next topic
|
| Author |
Message |
withnams
New User
Joined: 06 Jul 2005
Posts: 26
Location: Chennai
|
|
|
|
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 |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
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 |
|
|
Anbudan
New User
Joined: 07 Sep 2005
Posts: 26
Location: Germany
|
|
|
|
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 |
|
|
|
|
