How to Delete VSAM Files with same HLQs

Priyaraghu · Posted: Wed Nov 16, 2005 3:08 pm

How to delete a set of VSAM files with the same High-level Qualifiers?
I need the JCL to delete, say 100 VSAM files, all of them having the same High-level Qualifiers. I dont want to hard-code the dataset names in the JCL. I need to delete them by just specifying their HLQs.

Can anyone Please Help on this?

superk · Posted: Thu Nov 17, 2005 1:03 am

How about using the DFSMSdss SAR utility:

Priyaraghu · Posted: Thu Nov 17, 2005 10:45 am

Thankyou so much
It worked!!
The code that you gave deletes all VSAM files with 3 qualifiers..
and if i give DATASET(HLQ.**) then it deletes VSAM files with any number of qualifiers which have the same HLQ.

Thank you so much!!

raajan_p · New User Joined: 19 Sep 2005 Posts: 17

what changes do i need to make in the jcl if i need to do the same thing(i.e delete some 100 files with same qualifier) for flat files.

Regards,
Raajan

Priyaraghu · Posted: Thu Nov 17, 2005 3:38 pm

This utility can be used for files with DSORG SAM, PAM, PDS, PDSE, BDAM, EXCP, ISAM and VSAM. But it cannot be used for GDGs..

Kevin · Active User Joined: 25 Aug 2005 Posts: 234

Of course, for VSAM or QSAM or GDG, the alterative method would always work:

- Run IDCAMS LISTCAT LVL(HLQ) to get the list of datasets with matching High-Level qualifiers.

- Extract the dataset name from the lines identified like:

CLUSTER ------ HLQ.VSAM.CLUSTER.NAME
or
NONVSAM ----- HLQ.whatever

and plug those dataset names into IDCAMS DELETE statements:

DELETE (HLQ.whatever)

- Run IDCAMS with the dynamically generated DELETE list as input.