Re: Migrating IBM i database files to DB2 LUW

date: Thu, 5 Nov 2015 08:28:39 -0500
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: MIDRANGE-L Digest, Vol 14, Issue 1570

So you're mostly migrating to IBM i?

I believe you'll find you can use it to move from other DBs to DB2 (LUW or
i)

If you haven't already seen this page you might find it helpful..

https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/servers/enable/site/db2_porting_i.html

Charles

My primary duties are migrating old versions of our database (no database

constraints, data quality issues, lots of denormalization) to the latest
version of our database and system, where a huge portion of the database
has been redesigned, normalized, lots of database constraints, etc.. The
old and new databases are both on the IBM i platform.

I did perform one half of migration to SAP on another platform (all the
data extraction and most of the transformation), but the SAP portion of the
team required the data in a certain format where I highly doubt that IBM
toolkit would add much value to the process, since the SAP migration system
apparently has fairly strict import format requirements. I already have
that process highly automated now, so if we ever perform another one it
won't likely make sense to use additional tools.

Mike