Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 & Replace string in CA-SORT mrgnndhmk CA Products 1 Fri Mar 30, 2018 12:58 am
No new posts Find a string in PS file opened in br... mukkas CLIST & REXX 3 Sat Feb 24, 2018 2:15 pm
No new posts pointers on using USS and C programs. Pedro All Other Mainframe Topics 0 Wed Oct 04, 2017 4:38 am
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us