migrating from DB2 to Oracle

[jsquizz]

We are looking at moving from our onprem RHEL boxes that run CMOD 10.5 in a db2 environment, to an Azure environment running oracle.

We don't want to do arsdoc/arsload, because we have so much data. So, I guess our approach will be-

Export the db2 tables to oracle.
Move the mounts to oracle
Make sure all the mounts are "lined up"

I once saw a post on here, that had some high level steps, but I cant seem to find it now. does anyone have advice on doing this? or any tips.

Thanks!

[Justin Derrick]

I think that post was by Alessandro.  The only snag is, he was a prolific poster, so going through his history would take some time, and the instructions would be dated as he left the forums a few years ago.  :)

-JD.

[jsquizz]

I think that post was by Alessandro.  The only snag is, he was a prolific poster, so going through his history would take some time, and the instructions would be dated as he left the forums a few years ago.  :)

-JD.

yeah, i sent him an email earlier in the year when this was a hot topic.

It has since came up again with urgency..and the client thinks its 100% straightforward.

My opinion? extract/reload.

[Justin Derrick]

It should be possible to migrate the database tables directly and keep everything else...  I know that date format fields will be a problem since they're different between DB2 and Oracle.

-JD.

[TRDFan]

 We are actually looking at using"Heterogenous Links" within oracle.

I'm not much into oracle, 95% of my implementations have been DB2. My colleague who's an oracle/db2 dba thinks this is our best approach currently.

Will report back! This could be interesting.

[mani]

@jsquizz - Did you manage to find a solution for this? If so, please pots here the approach. Thanks.

[jsquizz]

@jsquizz - Did you manage to find a solution for this? If so, please pots here the approach. Thanks.

I have since left the project - however the plan was to use oracle's  "heterogenous link" functionality. I am not an oracle guru at all - but my colleague who was - said it should work.

https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity#:~:text=Oracle%20supports%20heterogeneous%20services%20to%20allow%20data%20in,uses%20ODBC%20or%20OLEDB%20to%20make%20the%20connections.

After the link is setup, migrate all the cache from onprem to azure.