VSAM file extract to SDS space Abend issue

morpheus007 · New User Joined: 27 Dec 2005 Posts: 58

We have a requirement to extract records of a VSAM file of the last 2 years to flat file and then FTP it.The VSAM file is so huge that even making half yearly or quarterly splits is still causing SB37 errors.However in the past writing to TAPE has worked.The problem is if I write to TAPE can it be ftp'ed.I had heard that TAPE files cannot be ftp;ed unless brought back to DISK.Kindly advice.Also there is an error called Broken Pipe that we encounter while ftp of large files.Is there a way to bypass it.

Devzee · Posted: Fri Aug 31, 2007 11:23 am

As you already tried to SPLIT it quarterly, why not try to split for each month and check.
After creating files, zip the file and do FTP.

Sjouke van der Schaaf · New User Joined: 30 Aug 2007 Posts: 5 Location: Amstelveen

You can make an multi volume output file by useing VOL=(,,,20)

expat · Posted: Fri Aug 31, 2007 12:43 pm

Sjouke van der Schaaf · New User Joined: 30 Aug 2007 Posts: 5 Location: Amstelveen

When you make your output file large enough, you don't get an SB37.
with the VOL=(,,,20) option, you can make the output file big enough.

If the dataset is to big for FTP, you can Zip the file.

morpheus007 · New User Joined: 27 Dec 2005 Posts: 58

I am sorry for the delay in having a look at the responses.

I had a look at the VOL=(,,,20) option.From what I can see it seems to go with UNIT=TAPE.Could it be coded with UNIT=SYSDA.I was under the assumption that TAPE files cannot be ftp'ed hence trying to avoid using TAPE.

expat · Posted: Fri Aug 31, 2007 4:11 pm

I know that either NDM or ConnectDirect easily cope with large files, and tape files.

Maybe you could ask if either of these products are available.

I have used them both, and they are good products.

Sjouke van der Schaaf · New User Joined: 30 Aug 2007 Posts: 5 Location: Amstelveen