This discussion is archived
7 Replies Latest reply: Aug 27, 2009 12:48 AM by 553937 RSS

Migration from DB2 V 8.1 to Oracle database

553937 Newbie
Currently Being Moderated
Hi,

I was looking for all the options available to migrate a DB2 V 8.1 Database running on OS/390 to Oracle 11g on Linux.

Oracle workbench does not support DB2 V8.x to Oracle. But want to confirm from the experts here.

Is there any other tools available to migrate from DB2 V 8.1 to Oracle.

Note : This is NOT a DB2 UDB or DB2/400.

Any help is appreciated.

Thanks,
Sbs
  • 1. Re: Migration from DB2 V 8.1 to Oracle database
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    You are correct, we don't have a migration workbench plugin for Db2 v8 either in the older Oracle Migration Workbench or the SQL*Developer based migration workbench.
    There is a note available in Metalink which discusses some options -

    Note.388615.1 Ext/Pub How To Migrate DB2 UDB V8

    but assuming you don't have access to Metalink I'll paste it here -

    Currently there is no plugin for UDB DB2 v8. There is an enhancement request (#4744020) logged to get this plugin.
    All customers requiring a V8 UDB plugin for OMWB should get in touch with Oracle Support and ask the support analyst to be subscribed to this enhancement request.
    Depending on the demands of this Plugin OMWB development will then decide to provide a plugin for UDB V8.


    This note outlines the options for migrating this database without using OMWB.

    The options to do a migration without using OMWB are -

    - use a gateway - such as TG4DRDA or generic connectivity - to do a 'create Oracle_table as select
    from DB2_table' for each table. You would then have to manually create all the other objects,
    permissions etc that existed in the DB2 database.

    - load the DB2 data into flat files and use SQL*Loader to put into Oracle tables. Again manual
    work is required for the other objects.

    - contact the Oracle Product Technology Services (PTS) group for assistance. See the webpage -

    http://www.oracle.com/technology/tech/migration/isv/mig_services.html

    - use a third party migration tool. See -

    http://www.oracle.com/technology/tech/migration/isv/third_party.html

    These companies may also be able to help specifically with DB2 V8 -


    http://www.ispirer.com/products/
    http://www.swissql.com/products/db2-to-oracle/db2-to-oracle.html
  • 2. Re: Migration from DB2 V 8.1 to Oracle database
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    Does this give you the information you need ?

    Regards,
    Mike
  • 3. Re: Migration from DB2 V 8.1 to Oracle database
    386080 Newbie
    Currently Being Moderated
    Hi Mike, Can you give me the latest update of options what we have as on today?

    Thanks in advance,
    Irfan
  • 4. Re: Migration from DB2 V 8.1 to Oracle database
    mkirtley-Oracle Expert
    Currently Being Moderated
    Irfan,
    There is still no change to the options listed in the previous updates.
    Last update I had was that it is still planned to release a tool for migrating DB2 v8 but there is currently no release date.

    Regards,
    Mike
  • 5. Re: Migration from DB2 V 8.1 to Oracle database
    386080 Newbie
    Currently Being Moderated
    Hi Mike , I dont believe Oracle doesnt have options. Only the thing is they dont want to make it public. There should be a way out on this. Lemme see if I can hit on the target.

    Thanks Again,
    Irfan
  • 6. Re: Migration from DB2 V 8.1 to Oracle database
    mkirtley-Oracle Expert
    Currently Being Moderated
    Irfan,
    All I can repeat is what has already been said -

    Currently there is no plugin for UDB DB2 v8 for OWMB or SQL*Developer migration workbench.

    Development are aware of the need and are working on it. The only migration options using Oracle software are those outlined earlier.

    Regards,
    Mike
  • 7. Re: Migration from DB2 V 8.1 to Oracle database
    553937 Newbie
    Currently Being Moderated
    Hi mkirtley ,

    Sorry, I didnt notice the updates you had given. Thanks for the pointers.

    Yeah. I had gone through that metalink note.

    One approach would be to migrate it manually. Move the data from DB2 database to a flat files. There are few DB2 utilities which helps in extract the data from DB2 database and move it to a flatfile. Once that is done , move these flat files to the Oracle server and use sql loader.

    Yeah, definitely it would not be a straight forward process as mentioned above. We need to look into many aspects like data type incompatibility between DB2 and Oracle, any blobs ,clob objects issues , data size and many other factors.

    Regards,
    Sasi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points