Re: Migrating IBM i database files to DB2 LUW

Mike

I'd suggest you consider what has not been said enough here - between DB2 for LUW and DB2 for IBM i there is the ability to move data directly - you can set up in LUW a connection to IBM i and just work with it.

IOW, DB2 is DB2 no matter which platform it's on.

Now as to coming from SQL Server to DB2 (of whatever flavor), there might be other challenges. Requirements for certain formats - well, that might be the choice of the people involved - so you may have to live with that. But it's not necessarily a requirement of the underlying database. and If it's from DB2 of one stripe to DB2 of another stripe, well, any such team should know that that works easily.

Cheers
Vern

On 11/5/2015 11:19 AM, Mike Jones wrote:

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