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
 

 

If Deadlock, how to find the programs using the resources

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

New User


Joined: 27 Nov 2005
Posts: 4

PostPosted: Mon Nov 28, 2005 11:37 am    Post subject: If Deadlock, how to find the programs using the resources
Reply with quote

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
View user's profile Send private message

Hames

New User


Joined: 03 Oct 2005
Posts: 49

PostPosted: Mon Nov 28, 2005 12:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
paulstephen

New User


Joined: 20 Oct 2005
Posts: 20
Location: Chennai

PostPosted: Mon Nov 28, 2005 2:48 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Hames

New User


Joined: 03 Oct 2005
Posts: 49

PostPosted: Mon Nov 28, 2005 3:27 pm    Post subject:
Reply with quote

Hi Paul,

How you'll go to DB2MON.

Can you give me the steps.
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
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm


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