I wonder how will it solve the Hebrew reading direction issue... ITschak
בתאריך 9 בינו׳ 2018 7:51 לפנה״צ, "Timothy Sipples" <[email protected]> כתב: > 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
