How to konw who is using the dataset?



TSO Programming, ISPF, SDF, SDSF and PDF, FTP, TCP/IP Concepts, SNA & SNA/IP etc...

How to konw who is using the dataset?

Postby Kevin H » Fri Feb 27, 2009 9:58 am

I can't update a dataset ,and it seems someone else is using it or it is open.
Is there any way to know the user_ID which is using the dataset? Like cmd or settings or something else?
Kevin H
 
Posts: 3
Joined: Fri Feb 27, 2009 7:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: How to konw who is using the dataset?

Postby dick scherrer » Fri Feb 27, 2009 10:27 am

Hello Kevin and welcome to the forum,

In tso/ispf, list the dataset.

Place an I or B or whatever and press enter.

You will probably see a message that says "dataset in use".

Press F1 twice and the system will show who/what has the dataset.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to konw who is using the dataset?

Postby Kevin H » Fri Feb 27, 2009 10:52 am

thanks, man!
Kevin H
 
Posts: 3
Joined: Fri Feb 27, 2009 7:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: How to konw who is using the dataset?

Postby dick scherrer » Fri Feb 27, 2009 11:05 am

You're welcome :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to konw who is using the dataset?

Postby hakghen » Mon Mar 09, 2009 9:39 pm

Or you could use the command WHOHAS, it would give you a list... Tho, I think it vary from system to system...
[]'s,

Hakghen
User avatar
hakghen
 
Posts: 59
Joined: Thu Sep 11, 2008 8:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to konw who is using the dataset?

Postby dick scherrer » Mon Mar 09, 2009 11:36 pm

Hello,

WHOHAS is completely site-specific. PF1 works on all systems. . . At least all of the systems, i've used. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to konw who is using the dataset?

Postby manojlives » Thu Jun 11, 2009 6:35 am

give this command

"GETENQ" it gives the ID or JOB name that uses this dataset.... I'm not sure whether it is system specific.....
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to konw who is using the dataset?

Postby Anuj Dhawan » Mon Jun 29, 2009 3:51 pm

Hi Dick,
Place an I or B or whatever and press enter.
I believe, "I" or "B" 'will be allowed even if the DSN is use at other end. Will such ISPF commands deiffer shop to shop?

"E" will throw the message for sure.

"GETENQ" does not work for me -- sounds like site specific.
Anuj
Anuj Dhawan
 
Posts: 273
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: How to konw who is using the dataset?

Postby dick scherrer » Tue Jun 30, 2009 2:06 am

Hi Anuj,

I or B will receive the "in use" error if something else has the qsam dataset as disp=old.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to konw who is using the dataset?

Postby AdriaanOlivier » Fri Aug 21, 2009 9:13 pm

thanks been look for alturnative way off doing that but i dont have access to do it with the command "denq" next to the dataset. Thanks a lot.
AdriaanOlivier
 
Posts: 4
Joined: Fri Aug 21, 2009 8:51 pm
Has thanked: 0 time
Been thanked: 0 time

Next

Return to TSO & ISPF

 


  • Related topics
    Replies
    Views
    Last post