REXX to find who is using a dataset currently

sangiah · New User Joined: 10 Jun 2005 Posts: 62

Any one has a REXX to find who is using a dataset currently.

jz1b0c · Posted: Wed Jun 15, 2005 1:26 pm

Hi,
There must be a clist already coded for this,

you can try TSO WHOHAS 'abcd.xyz.dataset'

if you are in TSO Command (6 option from primary ISPF)
then simply type WHOHAS 'abcd.xyz.dataset'

MGIndaco · Posted: Wed Jun 15, 2005 1:49 pm

I think that TSO WHOHAS is not a standard of IBM, I tried but for me it doesn't work.
If it's tha same for you try with TSODSN and outtrap the message.
Command is TSO TSODSN 'filename'

P.S.=I can't assure your that this is official...

Zai Cabading · New User Joined: 11 May 2005 Posts: 7

both TSO WHOHAS and TSO TSODSN works for me... just now that I tried TSO TSODSN...

regards,
zai

sangiah · New User Joined: 10 Jun 2005 Posts: 62

both did not work for me

superk · Posted: Thu Jun 16, 2005 3:57 pm

The WHOHAS utility is a shareware program that you should be able to locate from an Internet search. Also, sangiah, the other posts you made in this forum are also shareware programs that you should be able to locate. I'd ask your Systems Programming folks first. Maybe they would know where to find them.

For what it's worth, you can, of course find who is using a dataset by entering HELP when you receive the error message that the dataset is in use. Also, you can always contact one of your operators in the Data Center. This can also be determined by issuing a specific MVS command at the Master Console.

priyesh.agrawal · Posted: Thu Jun 16, 2005 4:16 pm

As SUPERK said here....

MGIndaco · Posted: Thu Jun 16, 2005 9:48 pm

Ok, mystery bypassed through a console command:

priyesh.agrawal · Posted: Thu Sep 01, 2005 5:53 pm

In case of a VSAM dataset pressing F1 twice doesn't work.

How can we know the job/user using VSAM Dataset.

MGIndaco,

How to run this console command you gave below ?

Regards,

Priyesh.

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

HI Priyesh,

priyesh.agrawal · Posted: Thu Sep 01, 2005 6:17 pm

That doesnt work for me....

Regards,

Priyesh.

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

Hi Priyesh,

It may be shop dependent. It is working for me.

Regards
Rupesh

MGIndaco · Posted: Thu Sep 01, 2005 6:40 pm

Hi Priyesh.
Put the PROC into a SYSPROC library concatenated or in your library and type EX near the member to execute it.(If you put it in a concatenated library you can also call it with the command TSO xxx <- name of the member given to it)

priyesh.agrawal · Posted: Thu Sep 01, 2005 6:54 pm

Thanks MGIndaco,

I executed it...But was not authorized to use OPERATOR Command.

YOUR INSTALLATION MUST AUTHORIZE USE OF OPERATOR COMMAND

Well, Thanks a lot for the help...

Hit & Trial worked for me.....& I got TSO WHO working fine for me.....

Regards,

Priyesh.

MGIndaco · Posted: Thu Sep 01, 2005 7:55 pm

This is another sample of PROC that does not use OPER:

priyesh.agrawal · Posted: Thu Sep 01, 2005 8:03 pm

We dont have member GRSDSENQ in SYS1.LINKLIB.

MEMBER GRSDSENQ NOT IN DATA SET SYS1.LINKLIB

Regards,

Priyesh.

MGIndaco · Posted: Thu Sep 01, 2005 8:22 pm

Ok, nothing to do...
It's from customizing.
This is not my fortunate day.

sumanth_toom · New User Joined: 15 Dec 2006 Posts: 6 Location: ..

Use SYSDSN against the PDS or
TSO SYSDSN <file-name>

dick scherrer · Posted: Thu Jul 23, 2009 1:23 am

Hello,

Please be aware that you replied to a topic that has been inactive for almost 4 years. . .

MBabu · Posted: Thu Jul 23, 2009 5:00 am

and SYSDSN is another local command. One way that will work on all IBM systems (save those in GRS STAR mode), whatever that is) is the QUERYENQ service of ISPF.

sumanth_toom · New User Joined: 15 Dec 2006 Posts: 6 Location: ..

The idea was to archive/share the information. Just incase someone had the same problem in future ;)

enrico-sorichetti · Posted: Thu Jul 23, 2009 2:57 pm

sumanth_toom · New User Joined: 15 Dec 2006 Posts: 6 Location: ..

Well it worked for me in couple of different shops !!
Here is the screenshot of how the output looks like..
(masked the some parts of the output..)

In case of multiple users/jobs using it,,all those are listed here as well !

sumanth_toom · New User Joined: 15 Dec 2006 Posts: 6 Location: ..

@enrico-sorichetti
I have also used SYSDSN in REXX to find out if the dataset exists or not..
(The link you posted..)..but i am not sure if both are same !!

expat · Posted: Thu Jul 23, 2009 4:44 pm

Are you using SYSDSN as a parameter of GRS, as opposed to SYSDSN as a TSO command ?