View previous topic :: View next topic
|
Author |
Message |
venkataramanak
New User
Joined: 27 Nov 2005 Posts: 4
|
|
|
|
Hi frens,
If deadlock occurs in your program, how come you know which program or user trying to access the same resources which is requested by you
Regards,
venkat |
|
Back to top |
|
|
Hames
New User
Joined: 03 Oct 2005 Posts: 49
|
|
|
|
Hi Venkataramana,
(i) You have to find the TABLE name from the job listing.
(ii) Note down the Job run time. Find in the same time any other job is running.
(iii) Now you can check jobs from step (ii) for using the TABLE from step(i).
Now you have identified the TABLE name and Job name which causes the deadlock.
For solution: You have to check its every day run. If its giving deadlock on every day, you have to change the second job run time after the completion on first job.
If you need further information let me know!!! |
|
Back to top |
|
|
paulstephen
New User
Joined: 20 Oct 2005 Posts: 20 Location: Chennai
|
|
|
|
Go to DB2MON in ur TSO session.
In that u will clearly be able to see job name, user id, querry etc... |
|
Back to top |
|
|
Hames
New User
Joined: 03 Oct 2005 Posts: 49
|
|
|
|
Hi Paul,
How you'll go to DB2MON.
Can you give me the steps. |
|
Back to top |
|
|
|