Could you please suggest what should be our approach and any solutions would be much appreciated.
We've thought of following.
1. Pulling data using FTP (our iSeries has a FTP server setup). But I'm not sure if I can run a Unix Script to connect to this FTP server on Solaris. If I have to use FTP on Solaris, do I have to use any special add-ons?
2. Oracle Gateways on the iSeries: Our DBA is working on this scenario, but we're not sure if this is the way to go.
If your company is lacking Java skills or would prefer another method, you might want to consider Websphere Information Integrator (Formerly DB2 Information Integrator - DB2 II). When you need to access a non-DB2 data source from an iSeries program written in any high-level programming language, DB2 II is a great solution. Be warned that it does require the data access to be performed with an SQL-based interface such as CLI, embedded SQL, or JDBC. For more information on DB2 Information Integrator and other methods of accessing non-DB2 data sources, view the white paper "Heterogeneous Data Access for iSeries Applications"
Regarding the FTP question, you can use FTP to pull data from a Solaris server. You would first want to export the Oracle data into a delimited format and than FTP the delimited data to the iSeries server and then use the CPYFRMIMPF CL command.
There are also third-party data replication products that support going from Oracle to DB2 UDB for iSeries.
MORE INFORMATION ON THIS TOPIC
Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.
Check out this Search400.com Featured Topic: Expert advice on DB2
Search400.com's targeted search engine: Get relevant information on DB2/400.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading