To delete s list of dataset in a PS file using JCL

d katkuri · New User Joined: 27 Feb 2013 Posts: 16 Location: india

JCL Requirement:
--------------------

From development team on a weekly basis I will recieve a PS file which contains list of datasets - .

PS File:
ABC.DATASET1
ABC.DATASET2

I need to read all the datasets from a PS file and to search in production JCL/PROC lib. If the dataset is not there in the JCL/PROC Lib then I need to delete the dataset from the system catalg.

Please provide a sample code with JCL

enrico-sorichetti · Posted: Fri Apr 19, 2013 3:49 pm

d katkuri · New User Joined: 27 Feb 2013 Posts: 16 Location: india

Hi enrico,
could you please let me know how can i acheive this task.

expat · Posted: Fri Apr 19, 2013 4:25 pm

So what if the dataset isn't in the JCL/PROC libraries

Correct storage management techniques should deal with the situation without such meanderings through libraries

enrico-sorichetti · Posted: Fri Apr 19, 2013 4:27 pm

pretty scaring approach

d katkuri · New User Joined: 27 Feb 2013 Posts: 16 Location: india

what if the dataset isn't in the JCL/PROC libraries
--------------------------------------------------------
Need to delete the dataset .

d katkuri · New User Joined: 27 Feb 2013 Posts: 16 Location: india

Enrico,
Could you please let me know the approach

Anuj Dhawan · Posted: Fri Apr 19, 2013 6:21 pm

ibmmainframes.com/viewtopic.php?p=310811#310811

expat · Posted: Fri Apr 19, 2013 6:41 pm

Akatsukami · Posted: Fri Apr 19, 2013 8:18 pm

dick scherrer · Posted: Fri Apr 19, 2013 9:10 pm

Hello and welcome to the forum,

Just my $.02 . . .

When datasets are newly created, there should be published purge criteria.

This should determine deletion of datasets raher than whether some dsn in in "the jcl" anywhere.

If the intent is to proceed this way, suggest you backup the "discovered" files before deletion . . . Just in case.

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

Wait wait wait.

Am I reading that wrong? You get a listing of cataloged datasets. Then you want to search through the JCL/PROC libraries to see if those datasets are REFERENCED by the JCL/PROC?

If you don't find any reference, then you want to remove the dataset?

Did I get the requirement correct?

d katkuri · New User Joined: 27 Feb 2013 Posts: 16 Location: india

yes goodman !!

We can do it by using sort/rexx . Could yo u help me ?

PeterHolland · Posted: Tue Apr 23, 2013 2:24 pm

And how about dataset names resolved by substitution of symbolic parameters?

And what has development to do with production data ?

enrico-sorichetti · Posted: Tue Apr 23, 2013 2:25 pm

Robert Sample · Posted: Tue Apr 23, 2013 2:39 pm

Personally, I think your entire premise is flawed. A data set could be allocated dynamically, in which case you would NEVER see a DD name referencing the data set yet it could be used every day of the year. And then your code deletes this data set ....

A more robust approach would be to work out HSM migration rules for data sets such that data sets that have not been used in X days get moved to level 1; if not used in another Y days they get moved to level 2; if not used in Z days then HSM deletes them.

expat · Posted: Tue Apr 23, 2013 2:51 pm

Robert, that's what I've been trying to tell him from the off

enrico-sorichetti · Posted: Tue Apr 23, 2013 2:53 pm

and the TS keeps pestering ,
just started a new topic asking for a REXX solution now

enrico-sorichetti · Posted: Tue Apr 23, 2013 3:04 pm

if the TS instead of pestering had simply googled for REXX ISRSUPC
he would have already found a working solution ,
not exactly the same, but close enough
the solution I found just searches for a single string
not difficult to write a wrapper to read the <string> list and ... ... ...

dick scherrer · Posted: Tue Apr 23, 2013 8:21 pm

Hello,

If you intend to actually implement this, you need to make sure you have direction (in writing from management) that all of these datasets not in the jcl/proc libraries are to be deleted.

If you just do this "on your own" and something needed is deleted, there may be consequences . . .