OK, first comment: why the **** are you FTP'ing data in the first place? This isn't 1989 any more. :-) And this is a serious question. It's increasingly expensive and fraught with security risks to copy data wantonly. What's this PC going to do with a bulk, point-in-time dump of all this data?
Now, trying to answer your question directly (and perhaps at your own peril): 1. I see in DB2-L that Kai Stroh already suggested checking your UNLOAD options. That's a good suggestion. 2. You can very likely use an ETL/ELT tool that specializes in this sort of work, notably IBM InfoSphere DataStage (preferably running on the IBM Z machine itself). InfoSphere DataStage Version 11.7 was released in December, 2017. 3. The Db2 cross-loader function is another possible option, as a part of the data journey anyway. You would set up a Db2 instance on the target platform (such as on the IBM Z machine itself, with Db2 for Linux), and you'd use the cross-loader function, with Db2 for z/OS as the input and Db2 on the other machine as the target. If any encoding scheme conversion is required, the cross-loader should handle it. You can find some more information on the cross-loader here (Db2 for z/OS Version 12 assumed): https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/ugref/src/tpc/db2z_loadusecrossloaderfunction.html 4. Db2 High Performance Unload for z/OS might add some value here. The latest version is 5.1 as I write this. 5. One more try per the first comment: just access the data (more securely) using Db2 for z/OS native RESTful interfaces (HTTPS instead of FTP). See here for details, in brief: http://www.idug.org/p/bl/et/blogid=477&blogaid=544 http://db2geek.triton.co.uk/db2-native-rest-api-getting-started/ -------------------------------------------------------------------------------------------------------- Timothy Sipples IT Architect Executive, Industry Solutions, IBM Z and LinuxONE, AP/GCG/MEA E-Mail: [email protected] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
