To know whether any Particular Dataset is in use or not

nallapureddy · New User Joined: 27 Jul 2005 Posts: 18

Is there any Command in CLIST or REXX to know whether any Particular Dataset is in use or not?

Nallapureddy

superk · Posted: Tue Aug 02, 2005 6:22 pm

jz1b0c · Posted: Fri Aug 05, 2005 10:35 am

Hi Nallapureddy,
if I have understood correctly...

This will work for you..

TSO WHOHAS 'YOUR.DATASET.NAME' this command is going to tell you
if any job/or user holding 'YOUR.DATASET.NAME'

bluebird · Active User Joined: 03 Feb 2004 Posts: 127

also if you are trying to edit a sequential ds and somebody is already editing it
you'll get a dataset in use msg . press F1 and you will have a list of users enqueueing your ds.

MGIndaco · Posted: Tue Aug 23, 2005 2:29 pm

I think that this can be useful:
http://ibmmainframes.com/viewtopic.php?t=3619

Ajay Baghel · Posted: Wed Apr 25, 2007 3:08 pm

I know how to do it in ISPF.

Step1-> TSO ISRDDN or go to option 6 in ISPF.
Step2-> In that give ENQ in the command Line, a screen will popup
Step3-> infront of Minor name prefix option, Enter Dataset name (See the screen shot. )
Step4-> Hit enter
You get the list of all jobs currently using the dataset.

hope it helps.

dick scherrer · Posted: Wed Apr 25, 2007 10:31 pm

Hello,

Most of those suggestions are how to find "who" has the dataset.

The original question is

ofer71 · Posted: Thu Apr 26, 2007 12:54 am

This is how I would do it:
1. Write REXX exec to capture the dataset name;
2. Invoke edit-macro internally, using the EDIT service;
3. Capture and interpret the return code from the edit-macro.
4. Display a message.

O.

Ajay Baghel · Posted: Fri Apr 27, 2007 12:36 pm

Use REXX built-in function SYSDSN to find whether the dataset is available for your use.

eg; x = SYSDSN("'proj5.rexx.exec'")

Mickeydusaor · Posted: Fri Apr 27, 2007 8:09 pm

ARG FILENAME

FILECODE = SYSDSN("'"FILENAME"'")

IF FILECODE = 'OK'
THEN DO
RTRNCODE = 8
END
ELSE DO
RTRNCODE = 0
END

enrico-sorichetti · Posted: Sat Apr 28, 2007 8:42 pm

A few remarks

The poster wants to know how to find out if a dataset is in use..
>> if somebody else has it allocated

WHOHAS is certainly a local tool

SYSDSN will only return info on the dataset existance

a trick that could be used is to
allocate it with disposition OLD in order to get exclusive control on it,
if the allocation fails then it is in use, to find out about users holding it
then other tools are needed.

regards

e.s

Mickeydusaor · Posted: Mon Apr 30, 2007 10:53 pm

enrico-sorichetti

you need to read up on SYSDSN as it will tell you if the dataset
is in use.

enrico-sorichetti · Posted: Tue May 01, 2007 12:37 am

TizMe · New User Joined: 05 Jan 2006 Posts: 72

ISPEXEC QUERYENQ is described in the ISPF Services Guide.

It will tell you if a dataset is in use.