OraFAQ Forum: Other Operating Systems » Database Migration from mainframe DB2 to Oracle

Home » Infrastructure » Other Operating Systems » Database Migration from mainframe DB2 to Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Migration from mainframe DB2 to Oracle [message #127754]

Wed, 13 July 2005 02:50

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

Report message to a moderator

Re: Database Migration from mainframe DB2 to Oracle [message #127782 is a reply to message #127754]

Wed, 13 July 2005 05:37

Maaher
Messages: 7064
Registered: December 2001

Senior Member

Can't you use this:
http://www.oracle.com/technology/tech/migration/workbench/index.html

MHE

Report message to a moderator

Re: Database Migration from mainframe DB2 to Oracle [message #127883 is a reply to message #127782]

Wed, 13 July 2005 20:27

schroeder
Messages: 2
Registered: July 2005
Location: australia

Junior Member

Fantastic, this is a very useful resource.

Thank you very much!

Report message to a moderator

Re: Database Migration from mainframe DB2 to Oracle [message #129507 is a reply to message #127754]

Mon, 25 July 2005 08:53

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!

Report message to a moderator

Re: Database Migration from mainframe DB2 to Oracle [message #380142 is a reply to message #129507]

Fri, 09 January 2009 04:52

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

Report message to a moderator

Re: Database Migration from mainframe DB2 to Oracle [message #380144 is a reply to message #380142]

Fri, 09 January 2009 05:16

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 18 15:32:46 CDT 2022