Ask the Expert

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 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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: