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
 

 

Finding locks on z/OS DB2?

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

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Fri Aug 22, 2014 11:55 pm    Post subject: Finding locks on z/OS DB2?
Reply with quote

I just started working for a group that is using mainframe DB2 as their backend for a distributed system.

This morning, there was a question like "what is locked up?"

I remember being able to use system tables to track down a deadlock on a server DB years ago. I never really kept up with the system side of DB2, so I I don't know if we can do that.

Everything I find talks about the snapshot_ functions, which I think are only for UDB.

So, how does an application programmer track down a deadlock? I'm not an admin.
Back to top
View user's profile Send private message

Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Sat Aug 23, 2014 12:02 am    Post subject:
Reply with quote

Many years ago, I think I used to look in SDSF at the MSGUSR DDNAME of the region involved to see what was deadlocked with what. Very rusty in that area though.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Sep 02, 2014 12:09 pm    Post subject:
Reply with quote

Hi Ed,

If related to deadlocks and timeouts, you can find the related information like who was holding it in the DB2 MSTR(ssidMSTR) log in spool.

If you have DB2-Insight, you can also check Current Contention(Main Menu, Active Threads --> Option 3(Curr Contn)

Thanks,
Sushanth
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 Finding unreferenced datasets without... Alan Playford JCL & VSAM 5 Tue Jul 12, 2016 9:07 pm
No new posts Finding repetead surnames in differen... blackjack202 DFSORT/ICETOOL 7 Tue Jun 07, 2016 7:42 pm
No new posts Need help in Finding who changed the ... steve-myers JCL & VSAM 6 Wed Jan 27, 2016 9:01 pm
No new posts Finding a File Containing a Particula... rexx77 DFSORT/ICETOOL 8 Tue Dec 22, 2015 2:19 am
No new posts Finding out consecutive date entries ... bhavya_sha DFSORT/ICETOOL 10 Fri Nov 20, 2015 3:24 pm


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