DSXchange

That makes sense. Thanks for your suggestion.
My concern here is mainly focus on performance.

We are using FTP just to bypass the network traffic during the load operation. In our workshop, FTP + Load locally is much faster than Load from Client. No matter what, DB2 client has to be installed on DataStage server in order to connect to DB2 database server. Anyway, I will do a test to see how ...

Thanks for all of your responds. Yes, the NFS can simplify the data loading process management. However, my concern is, for those large volume table loading (e.g 4G), compare "Compress --> FTP --> decompress -->DB2 Load" , how does the DB2 Load performance if the input datafile is under th...

Usually, we use FTP to transfer a datafile from DataStage server to DB2 database server and Load data locally. Now we are thinking to build a NFS on DataStage server, DB2 database server will be the NFS client. So the DB2 Load utility can be run on the database server without FTP operation. However,...

I'm a DBA. I'd like to explore ETL knowledges. As DataStage v7.5 is being used in our workshop, is there any DataStage 101 online so I could get a quick start on the product?

Any help will be much appreicated.