Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Deleting a multiple VSAM files with different HLQs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Deleting a multiple VSAM files with different HLQs
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: 788
Location: Chennai, India

PostPosted: Wed Apr 09, 2008 4:03 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Apr 09, 2008 4:17 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Apr 09, 2008 4:24 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Wed Apr 09, 2008 9:12 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Thu Apr 10, 2008 11:55 am    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Thu Apr 10, 2008 1:07 pm    Post subject: Reply to: Deleting a multiple VSAM files with different HLQs
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: 8593
Location: Back in jolly old England

PostPosted: Thu Apr 10, 2008 1:42 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us