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
 

 

VSAM file extract to SDS space Abend issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Fri Aug 31, 2007 9:01 am    Post subject: VSAM file extract to SDS space Abend issue
Reply with quote

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.
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Aug 31, 2007 11:23 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Sjouke van der Schaaf

New User


Joined: 30 Aug 2007
Posts: 5
Location: Amstelveen

PostPosted: Fri Aug 31, 2007 12:38 pm    Post subject:
Reply with quote

You can make an multi volume output file by useing VOL=(,,,20)
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: Fri Aug 31, 2007 12:43 pm    Post subject:
Reply with quote

Sjouke van der Schaaf wrote:
You can make an multi volume output file by useing VOL=(,,,20)


How does this solve the original problem. If you reread the OP, using large files is also problematic.
Back to top
View user's profile Send private message
Sjouke van der Schaaf

New User


Joined: 30 Aug 2007
Posts: 5
Location: Amstelveen

PostPosted: Fri Aug 31, 2007 1:10 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Fri Aug 31, 2007 3:27 pm    Post subject: Reply to: VSAM file extract to SDS space Abend issue
Reply with quote

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.
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: Fri Aug 31, 2007 4:11 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Sjouke van der Schaaf

New User


Joined: 30 Aug 2007
Posts: 5
Location: Amstelveen

PostPosted: Tue Sep 04, 2007 2:11 pm    Post subject: Re: Reply to: VSAM file extract to SDS space Abend issue
Reply with quote

morpheus007 wrote:
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.



The Vol option can also be used with disk, in this matter you won't be restricted to 1 volume, but an extend can be taken on an other disk
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
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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