Page 1 of 1
Read a file from Mainframe server & write it to a UNIX b
Posted: Tue Mar 02, 2010 5:01 pm
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.
Posted: Tue Mar 02, 2010 5:26 pm
by ray.wurlod
Welcome aboard.
Why not FTP? The same volume of data will be moved.
Posted: Tue Mar 02, 2010 10:19 pm
by nagarjuna
as specified by ray , you have to transfer the file anyways so do SFTP or FTP
Re: Read a file from Mainframe server & write it to a UN
Posted: Wed Mar 03, 2010 10:05 am
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.
Posted: Wed Mar 03, 2010 10:37 am
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?
Re: Read a file from Mainframe server & write it to a UN
Posted: Wed Mar 03, 2010 11:31 am
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
Re: Read a file from Mainframe server & write it to a UN
Posted: Wed Mar 03, 2010 11:32 am
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
Posted: Wed Mar 03, 2010 3:13 pm
by DSguru2B
Look into Classic Federation. Then you can access datasets, vsams and all that good stuff via odbc connectors.
Re: Read a file from Mainframe server & write it to a UN
Posted: Sat Mar 06, 2010 9:43 pm
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.