Performance comparison of FTP Stage - Server and Parallel

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
vnspn
Participant
Posts: 165
Joined: Mon Feb 12, 2007 11:42 am

Performance comparison of FTP Stage - Server and Parallel

Post by vnspn »

Hi,

We are currently working on Server Edition and are planning to move to Enterprise Edition in the near future.

Recently we tried to ftp a file from Mainframes using the FTP stage. It turned out to be a bit pretty slow. It processed at about 120 rows/sec as shown in the performance statistics.

We are just curious to know if the parallel job could give a better performance with the FTP stage that is in the parallel canvas. If anyone have tried this kind of comparison, please share your information. Also, if you had used parallel FTP stage to read a file from Mainframes, then what was the speed / performance at which it had processed?

Thanks.
Post Reply