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.


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

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



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.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].