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
 

 

Is there any way to find out who is holding the dataset?

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

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Tue Aug 12, 2008 10:54 pm    Post subject: Is there any way to find out who is holding the dataset?
Reply with quote

Hi all,

I would like to know, how to find out the resource name who is holding the data set.

***
If my question is not appropriate, pls excuse me****
Back to top
View user's profile Send private message

Suresh Ponnusamy

Active User


Joined: 22 Feb 2008
Posts: 107
Location: New York

PostPosted: Tue Aug 12, 2008 11:32 pm    Post subject:
Reply with quote

Please try "TSO WHOHAS '<DATASET NAME>'"
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10234
Location: italy

PostPosted: Tue Aug 12, 2008 11:46 pm    Post subject: Reply to: Is there any way to find out who is holding the da
Reply with quote

whohas is usually site specific

in a vanilla ( no add ons ) environment

if You get the message trying to edit / view / browse under ispf
hit PF1 twice

if You are just curious enter TSO ISRDDN ENQ
and You will be taken to a panel wher You can specify
the deatils of Your ENQ search
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Tue Aug 12, 2008 11:49 pm    Post subject:
Reply with quote

suresh,
WHOHAS is site-specific routine for MVS dataset names.

satyender,
Because you're in the DB2 forum, are you asking about DB2 table locks?
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Wed Aug 13, 2008 12:28 am    Post subject:
Reply with quote

Thanks a lot.

When I used TSO ISRDDN ENQ its working fine. I could see who is using which dataset.

Thanks a lot enrico sorichetti.

Infact, Thanks to all, for your time and suggestions.
Back to top
View user's profile Send private message
Suresh Ponnusamy

Active User


Joined: 22 Feb 2008
Posts: 107
Location: New York

PostPosted: Wed Aug 13, 2008 2:36 am    Post subject:
Reply with quote

oh.. Ok.. thanks enrico and bill for correcting me.
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 Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am
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


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