Q

Migrating DB2 UDB database to Oracle on Linux

In the next couple of weeks I need to migrate from a DB2 UDB database running on an AIX system to Oracle running on Redhat Linux. 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?

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.

Reader feedback:

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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close