| View previous topic :: View next topic |
| Author |
Message |
vjkumk
Beginner
Joined: 28 Sep 2005
Posts: 98
Topics: 33
|
 Posted: Sat Sep 09, 2006 8:34 am Post subject: how to Find the progam and job names involved in deadlock. |
 |
|
I am a Beginner in mainframes.
Before posting my question,
I saw some topics, about deadlock and how it occurs, in your forum. like
-911(with rollback and deadlock) and -913(deadlock and without rollback).
My question is,
Suppose two or more programs or jobs which access the same table for update or delete and results in deadlock,how to find the program name and job name which are currently causing(Involved) the deadlock.
Appreciate your help.
VJ |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12394
Topics: 75
Location: San Jose
|
| Posted: Sat Sep 09, 2006 11:36 am Post subject: |
|
|
| Quote: |
Suppose two or more programs or jobs which access the same table for update or delete and results in deadlock,how to find the program name and job name which are currently causing(Involved) the deadlock.
|
vjkumk,
Search for DSNT375I messages in system log (sdfsf - option log). It displays all the pgms involved in deadlocks. Most shops have seperate jobs to extract this information to a seperate dataset.
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
vjkumk
Beginner
Joined: 28 Sep 2005
Posts: 98
Topics: 33
|
| Posted: Sat Sep 09, 2006 10:05 pm Post subject: |
|
|
Kolusu,thanks for the information
| Quote: |
Most shops have seperate jobs to extract this information to a seperate dataset.
|
Do we have any sample jobs in our forum ?Please let me know.
I am really eager to see how the coding is done for the job which gets this information.
Do we have any separate IBM utility to get this information,so that we can use it in JCL ?
thanks,
VJ |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12394
Topics: 75
Location: San Jose
|
| Posted: Sun Sep 10, 2006 12:46 pm Post subject: |
|
|
| Quote: |
Do we have any sample jobs in our forum ?Please let me know.
I am really eager to see how the coding is done for the job which gets this information.
|
vjkumk,
This is quite simple. SORT/File-aid/Rexx can be used to extract the information from the log files. Start reading from this post onwards and you will see how you can extract the data using sort
http://www.mvsforums.com/helpboards/viewtopic.php?p=28504#28504
| Quote: |
Do we have any separate IBM utility to get this information,so that we can use it in JCL ?
|
IBM has DB2 Performance Monitor ADD on tool for this reporting purpose. Check this link for info on it
http://www-306.ibm.com/software/data/db2imstools/db2tools/db2pm/index.html
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
