Migrating DB2 UDB database to Oracle on Linux
In the next couple of weeks I need to migrate from a DB2 UDB version 7.2 database running on an AIX 4.3.3 system to Oracle 10.2.0.2 running on Redhat Linux 4.2. It doesn't appear that I will be able to use the Oracle Migration Workbench because from the documentation it only supports migrating from a DB2 UDB database running on Windows platforms. Is this true?
It does appear that there is migration documentation available for DB2 UDB on the Windows platform only. I would say it does not appear that there is a migration tool available from Oracle that covers DB2 UDB on AIX. For more information, you can refer to Oracle's Migration Technology Center
There is a section with links to third-party software that might be helpful to you. There is also a link to the Oracle Database Conversion Guide for DB2 (OS/390) to Oracle9i. It is specific to the OS/390 platform but contains some useful information that may apply cross-platform when performing a migration like you have described.
Bob T. writes:
We discovered this exact problem a while back but we worked around the Windows requirement as follows: I would suggest that the person in this article might consider putting up a DB2 instance on Windows, export from AIX-db into Windows-db, then migrate from DB2 on Windows to Oracle on Linux.
This process works going from Oracle to MySQL or SQL Server, and with some tweaking it should work in reverse.
This was first published in September 2006