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
 
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 LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm
No new posts finding delayed job/s in OPC jzhardy IBM Tools 0 Mon May 29, 2017 9:04 am
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

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