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 

Dumping VSAM file into Sequential file

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


Joined: 21 Oct 2003
Posts: 70
Topics: 25

PostPosted: Fri May 07, 2010 10:37 am    Post subject: Dumping VSAM file into Sequential file Reply with quote

We are planning to create a VSAM KSDS file of length greater than 32K. Is there any way to take the backup of this this VSAM file into Sequential file on DASD or tape.

I tried 3.2 option but errored with out of range
I tried SORT, IDCAMS and other utility but was not able to achieve this.

Any thoughts please...

Thanks,
lal
Back to top
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1

PostPosted: Fri May 07, 2010 4:56 pm    Post subject: Reply with quote

Why do you believe you need records this large? Sounds like improper design. . .

Have you tried ADRDSSU? Have you talked with your storage management people to learn what additional tools might be available on your system?
_________________
All the best,

di
Back to top
View user's profile Send private message
expat
Intermediate


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

PostPosted: Mon May 10, 2010 5:03 am    Post subject: Reply with quote

Sometimes these length records appear in scheduling software such as OPC. (TWS).

My usual approach is to do a VSAM to VSAM copy and then back up the copy of the VSAM file. As suggested above, ADRDSSU (DFdss) and talk to your storage people.
_________________
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
lal
Beginner


Joined: 21 Oct 2003
Posts: 70
Topics: 25

PostPosted: Mon May 10, 2010 8:58 am    Post subject: Reply with quote

Thanks for the reply.
Our currently master file is VSAM-KSDS which is about 25K length due to the addition of other customer information the length of proposed file is going past 32K limit.

That's the reason I wanted to know if it was feasible to take the backup of the newly proposed master VSAM file using any utilities.

We do have ADRDSSU, so do you think that I can use this utility to take the backup of this big VSAM file.

Thanks,
lal
Back to top
View user's profile Send private message
expat
Intermediate


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

PostPosted: Mon May 17, 2010 7:08 am    Post subject: Reply with quote

Try it and see what happens.
_________________
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
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1

PostPosted: Mon May 17, 2010 2:05 pm    Post subject: Reply with quote

After the backup is created, make sure it can be reloaded into a test vsam file and used. It is a rather horrible discovery to learn that the backups created are not usable. . .

Until a backup has been reloaded and the data successfully used, all that exists is some media with questionable content. . .
_________________
All the best,

di
Back to top
View user's profile Send private message
lal
Beginner


Joined: 21 Oct 2003
Posts: 70
Topics: 25

PostPosted: Tue May 18, 2010 4:46 pm    Post subject: Reply with quote

Thanks everyone for your input.

Well, I used ADRDSSU's DUMP command to store the VSAM file and used the RESTORE command to restore the VSAM dataset back. It is working perfectly...

Thanks,
lal
Back to top
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1

PostPosted: Tue May 18, 2010 9:30 pm    Post subject: Reply with quote

Cool!

Thanks for letting us know it is working Very Happy
_________________
All the best,

di
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 -> Utilities 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