OnDemand User Group

Support Forums => MP Server => Topic started by: jsquizz on September 23, 2021, 08:23:46 AM

Title: migrating from DB2 to Oracle
Post by: jsquizz on September 23, 2021, 08:23:46 AM
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!
Title: Re: migrating from DB2 to Oracle
Post by: Justin Derrick on September 27, 2021, 07:35:15 AM
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.
Title: Re: migrating from DB2 to Oracle
Post by: jsquizz on September 27, 2021, 08:05:13 AM
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.
Title: Re: migrating from DB2 to Oracle
Post by: Justin Derrick on September 28, 2021, 09:16:28 AM
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.
Title: Re: migrating from DB2 to Oracle
Post by: TRDFan on September 28, 2021, 10:44:44 AM
 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.
Title: Re: migrating from DB2 to Oracle
Post by: Mani on January 11, 2022, 06:31:13 AM
@jsquizz - Did you manage to find a solution for this? If so, please pots here the approach. Thanks.
Title: Re: migrating from DB2 to Oracle
Post by: jsquizz on January 11, 2022, 08:11:19 AM
@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.