IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
Reply with quote

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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Aug 12, 2008 11:46 pm
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top