Home » Infrastructure » Other Operating Systems » Database Migration from mainframe DB2 to Oracle
Database Migration from mainframe DB2 to Oracle [message #127754] Wed, 13 July 2005 02:50 Go to next message
schroeder
Messages: 2
Registered: July 2005
Location: australia
Junior Member
hi all

First time question.

Can anyone please post any links to

Guidelines / Instructions / Procedures for migrating a DB2 database (tables, functions, indexes, procedures, etc) to Oracle.

I'll keep searching this site but so far haven't found anything.

Any help or pointers appreciated Smile


Schroeder
Re: Database Migration from mainframe DB2 to Oracle [message #127782 is a reply to message #127754] Wed, 13 July 2005 05:37 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Can't you use this:
http://www.oracle.com/technology/tech/migration/workbench/index.html

MHE
Re: Database Migration from mainframe DB2 to Oracle [message #127883 is a reply to message #127782] Wed, 13 July 2005 20:27 Go to previous messageGo to next message
schroeder
Messages: 2
Registered: July 2005
Location: australia
Junior Member
Smile Fantastic, this is a very useful resource.

Thank you very much!

icon14.gif  Re: Database Migration from mainframe DB2 to Oracle [message #129507 is a reply to message #127754] Mon, 25 July 2005 08:53 Go to previous messageGo to next message
ramesh_leadersoft
Messages: 3
Registered: July 2005
Junior Member
hai,
try out using oracle heterogenous services,it was an excellent on e which makes any non-oracle database to be queried from oracle itself.

a seperate tnsnames and listener and parameter file have to be maintained for this. with no 3rd party tool u can come out successfuly.

one greatest disadvantage is that the long datatype,clob,blob will not be supported in this,

if u have any problem call me in my ramsat_077@yahoo.com
bye!
Re: Database Migration from mainframe DB2 to Oracle [message #380142 is a reply to message #129507] Fri, 09 January 2009 04:52 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
I have to migrate a DB2 database to Oracle 10g but Oracle migration WorkBench supports only till version 7.0. I have to migrate DB2 8.1 version.

Please advice a way to do the same.

Regards,
Mahi
Re: Database Migration from mainframe DB2 to Oracle [message #380144 is a reply to message #380142] Fri, 09 January 2009 05:16 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
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

SOURCE

[Updated on: Fri, 09 January 2009 05:18]

Report message to a moderator

Previous Topic: Moving tablespaces cross-plataform
Next Topic: Configure ftp in linux
Goto Forum:
  


Current Time: Thu Mar 28 10:39:59 CDT 2024