MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

VSAM EMPTY

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
srinu14165
Beginner


Joined: 25 Aug 2006
Posts: 10
Topics: 5

PostPosted: Mon Apr 09, 2007 8:09 am    Post subject: VSAM EMPTY Reply with quote

Hi all,
Can anybody let me know, how to empty a vsam file.
Back to top
View user's profile Send private message
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48

PostPosted: Mon Apr 09, 2007 8:14 am    Post subject: Reply with quote

You can delete define the file.
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Apr 09, 2007 8:15 am    Post subject: Reply with quote

srinu14165,

1. Delete the cluster and re-define it

2. If the cluster is defined with REUSE then copy an empty flat file to the vsam cluster using SORT/FILE-AID

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
srinu14165
Beginner


Joined: 25 Aug 2006
Posts: 10
Topics: 5

PostPosted: Mon Apr 09, 2007 9:08 am    Post subject: Reply with quote

Hi all,
Thanks much for your response. I thought there would be some other easy way to do it, rather than del/define.

Anyway, I appreciate your prompt response
Back to top
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Wed May 02, 2007 2:26 am    Post subject: Reply with quote

Quote:
I thought there would be some other easy way to do it, rather than del/define.

What did you have in mind ? a DEL/DEf takes what, 2 seconds. What could be easier ?
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?
Back to top
View user's profile Send private message
blitz2
Beginner


Joined: 23 Jan 2007
Posts: 84
Topics: 14

PostPosted: Wed May 02, 2007 7:27 am    Post subject: Reply with quote

If del-def takes 2 seconds, editing the file directly takes 1 millisecond!
________
NO2 VAPORIZER


Last edited by blitz2 on Thu Mar 10, 2011 5:29 pm; edited 1 time in total
Back to top
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Wed May 02, 2007 8:25 am    Post subject: Reply with quote

Quote:
If del-def takes 2 seconds, editing the file directly takes 1 millisecond!

And if the file has nn millions of records ? Do you want to sit there and delete them all.

And, no doubt your shop has FILEAID installed, but not every shop does which would probably rule out your solution on a global scale.
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group