Page 1 of 2

How to konw who is using the dataset?

PostPosted: Fri Feb 27, 2009 9:58 am
by Kevin H
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?

Re: How to konw who is using the dataset?

PostPosted: Fri Feb 27, 2009 10:27 am
by dick scherrer
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.

Re: How to konw who is using the dataset?

PostPosted: Fri Feb 27, 2009 10:52 am
by Kevin H
thanks, man!

Re: How to konw who is using the dataset?

PostPosted: Fri Feb 27, 2009 11:05 am
by dick scherrer
You're welcome :)

d

Re: How to konw who is using the dataset?

PostPosted: Mon Mar 09, 2009 9:39 pm
by hakghen
Or you could use the command WHOHAS, it would give you a list... Tho, I think it vary from system to system...

Re: How to konw who is using the dataset?

PostPosted: Mon Mar 09, 2009 11:36 pm
by dick scherrer
Hello,

WHOHAS is completely site-specific. PF1 works on all systems. . . At least all of the systems, i've used. . .

Re: How to konw who is using the dataset?

PostPosted: Thu Jun 11, 2009 6:35 am
by manojlives
give this command

"GETENQ" it gives the ID or JOB name that uses this dataset.... I'm not sure whether it is system specific.....

Re: How to konw who is using the dataset?

PostPosted: Mon Jun 29, 2009 3:51 pm
by Anuj Dhawan
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.

Re: How to konw who is using the dataset?

PostPosted: Tue Jun 30, 2009 2:06 am
by dick scherrer
Hi Anuj,

I or B will receive the "in use" error if something else has the qsam dataset as disp=old.

Re: How to konw who is using the dataset?

PostPosted: Fri Aug 21, 2009 9:13 pm
by AdriaanOlivier
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.