Author Topic: migrating from DB2 to Oracle  (Read 1448 times)

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
migrating from DB2 to Oracle
« 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!
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: migrating from DB2 to Oracle
« Reply #1 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: migrating from DB2 to Oracle
« Reply #2 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.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: migrating from DB2 to Oracle
« Reply #3 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

TRDFan

  • Guest
Re: migrating from DB2 to Oracle
« Reply #4 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.

Mani

  • Jr. Member
  • **
  • Posts: 28
    • View Profile
Re: migrating from DB2 to Oracle
« Reply #5 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.

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: migrating from DB2 to Oracle
« Reply #6 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.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING