Read a file from Mainframe server & write it to a UNIX b

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Read a file from Mainframe server & write it to a UNIX b

Post by DSFreddie »

Hi All, I am trying to read a VSAM file from Mainframe Server & move it to the UNIX box for further processing. I know that we could ftp this file from Mainframe server to UNIX box. But since the file is huge (250GB), I do not want to FTP the file.

Can you pls tell me a way to read the file from Mainframe server & write it to UNIX box for further processing.
Last edited by DSFreddie on Sun Mar 07, 2010 8:54 pm, edited 1 time in total.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Welcome aboard.

Why not FTP? The same volume of data will be moved.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

as specified by ray , you have to transfer the file anyways so do SFTP or FTP
Nag
Top
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Re: Read a file from Mainframe server & write it to a UN

Post by DSFreddie »

Thanks a lot for your replies. The issue is that the file is very huge (250GB). The client doesnt want to go for an FTP/SFTP. Also, this is a Daily Batch & FTP process itself is going to take lot of time.

Any other workaround will be highly appreciated.

Thanks in advance.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

The only normal method of getting data from a host to a server is via FTP or a derivative (i.e. connect:direct or FLAM or the like). If you don't want to land the data on the UNIX machine you could use the DataStage FTP stage to read the data line-by-line and process it; but then you would need to build in restartability.

What format is this file in?
Top
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Re: Read a file from Mainframe server & write it to a UN

Post by DSFreddie »

Thanks for your response.

It is a VSAM file (Cobol Layout). I am actually trying to find a way through which we could accomplish this without using an FTP stage.

Thanks in advance.
Freddie
Top
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Re: Read a file from Mainframe server & write it to a UN

Post by DSFreddie »

Thanks for your response.

It is a VSAM file (Cobol Layout). I am actually trying to find a way through which we could accomplish this without using an FTP stage.

Thanks in advance.
Freddie
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Look into Classic Federation. Then you can access datasets, vsams and all that good stuff via odbc connectors.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
DSFreddie
Participant
Posts: 130
Joined: Wed Nov 25, 2009 2:16 pm

Re: Read a file from Mainframe server & write it to a UN

Post by DSFreddie »

DSFreddie wrote:Hi All, I am trying to read a VSAM file from Mainframe Server & move it to the UNIX box for further processing. I know that we could ftp this file from Mainframe server to UNIX box. But since the file is huge (250GB), I do not want to FTP the file.

Can you pls tell me a way to read the file from Mainframe server & write it to UNIX box for further processing.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”