Re: Migrating IBM i database files to DB2 LUW

On 11/3/2015 8:20 PM, Steve Landess wrote:

I don't have all the details yet, but I have an associate who needs to
migrate data from an AS/400 - iSeries - IBM i system to a DB2 LUW
database, most likely running on a Windows server.

I am not yet sure which version of either platform yet, but can anyone
provide what options are available which do NOT require the $$$$ DB2
Connect feature on the midrange side?

I did a subset of our tables for a proof of concept for some GIS work.
The GIS software ran ONLY against DB2 LUW. I forget the details, and it
was a while ago. The budget was zero dollars and 'use your spare time'.

My recollection was that I fired off the API that extracted the SQL DDL
and cut/pasted that DDL onto LUW scripts which created the tables.
Tweaked for LUW differences. Extracting the DDL might be do-able
entirely from SQL now, depending on the IBM i release level.

Then I used Scott's JDBC wrappers to write some RPG programs that read
the IBM i tables (using the cycle, ha!) and then doing an 'INSERT INTO'
on the remote LUW twin table. Inefficient, but it met my needs. It may
be easier to write a 'pull' from the LUW side; I'm an RPG programmer, so
everything looks like an RPG problem to be :-)