IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Deleting a multiple VSAM files with different HLQs


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Wed Apr 09, 2008 4:02 pm
Reply with quote

Hi!
I have to delete some 1000 VSAM files which have actually over-allocated. The files have different HLQs. I think i can take the list of the VSAM files as input in a file and then delete these files either using a COBOL program or using a JCL. But i dont know how to delete it using either of them!1 Is there a possibility of doing so?? Your help would be greatly appreciated..
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Wed Apr 09, 2008 4:03 pm
Reply with quote

IDCAMS DELETE...
Back to top
View user's profile Send private message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Wed Apr 09, 2008 4:08 pm
Reply with quote

I tried that but i am confused whether it can delete all the VSAM files with different HLQ??
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Wed Apr 09, 2008 4:17 pm
Reply with quote

Do you want to delete every VSAM file for a given HLQ, or only selected VSAM files ?
Back to top
View user's profile Send private message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Wed Apr 09, 2008 4:21 pm
Reply with quote

I want to delete only selected VSAM files.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Wed Apr 09, 2008 4:24 pm
Reply with quote

How will you know which files are to be deleted and which ones retained
Back to top
View user's profile Send private message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Wed Apr 09, 2008 4:37 pm
Reply with quote

Well, i have to delete all the files which are over-allocated. I have the list, and almost none of the files fall into certain criteria like putting them A.A.B.* or something like that. Hence, i think i can have a PS containing all these VSAM files and delete them one by one either through JCl or by a small program. But then is there a way to do so?? Or is there any other alternative approach??
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Wed Apr 09, 2008 9:12 pm
Reply with quote

Hello,

You could read the file containing the names of the datasets to delete and then generate the jcl and control statements to delete them.

One easy way would be to generate IDCAMS steps to delete the files.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Thu Apr 10, 2008 11:55 am
Reply with quote

A couple of suggestions

If your shop has FDR Compactor from Innovation Data Processing, that will release unused VSAM space.

If your SMS environment is set up with some thought then VSAM free space release is available too.
Back to top
View user's profile Send private message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Thu Apr 10, 2008 12:52 pm
Reply with quote

Thanks for your Suggestions!!
I am trying out the suggestion given by Dick since my shop doesnt have the FDR Compactor and evn the VSAM free space release is also not available.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Apr 10, 2008 1:07 pm
Reply with quote

lots of traffic when there is a simpler solution...
I would suggest...

edit the dataset list
insert a new line with ...

Code:
   delete                                              cluster purge

46 blanks in between

shift right the datast's names to align them with the second blank
after the delete

Code:
   delete                                              cluster purge
          12345678901234567890123456789012345678901234
           some.dataset

issue the line commands
"C" on the delete line
"O99999" on the other lines

delete the fisrt line
et voila' the idcams sysin ready to delete all Your datasets
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Thu Apr 10, 2008 1:42 pm
Reply with quote

rahuindo wrote:
Thanks for your Suggestions!!
I am trying out the suggestion given by Dick since my shop doesnt have the FDR Compactor and evn the VSAM free space release is also not available.


VSAM free space release became available with z/OS 1.3 - just needs the SMS configuration to be correctly set up.

As an additional comment, deleteing the files does seem a bit drastic for being over allocated. Do they get restored but smaller afterwards.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts 3 files concatenated to 1 DFSORT/ICETOOL 2
No new posts JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts combine multiple unique records into ... DFSORT/ICETOOL 2
No new posts SORT JCL to merge multiple tow into s... DFSORT/ICETOOL 6
No new posts Using Multiple IFTHEN and WHEN condit... SYNCSORT 12
Search our Forums:

Back to Top