Author Topic: Database Migration  (Read 1659 times)

Neosta

  • Newbie
  • *
  • Posts: 8
    • View Profile
Database Migration
« on: July 10, 2019, 03:58:16 AM »
HI,

I have CMOD 9.5 running with Oracle as back-end. I want to migrate my database to DB2.

Can someone please help with details and necessary steps required in CMOD database migration from Oracle to DB2.

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: Database Migration
« Reply #1 on: July 10, 2019, 07:12:05 AM »
How big is your production environment? Do you plan on upgrading CMOD from 9.5 to 10.1? Do you plan on upgrading storage medium (tsm, icos..etc..)
#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: Database Migration
« Reply #2 on: July 10, 2019, 01:20:36 PM »
Last time I heard of this being done, the migration from Oracle to DB2 is problematic because of the different data types.  I'm interested to see if Alessandro has something to say about this - I vaguely remember him mentioning it previously.

-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: Database Migration
« Reply #3 on: July 10, 2019, 02:36:09 PM »
Last time I heard of this being done, the migration from Oracle to DB2 is problematic because of the different data types.  I'm interested to see if Alessandro has something to say about this - I vaguely remember him mentioning it previously.

-JD.

I was going to do this also, but we changed our mind. We were then going to switch from DB2 AIX to ORACLE RHEL, and we were going to do a complete re-ingest. Not sure if it's something required for this scenario, but something to keep in mind- if they plan on going to new storage or anything like that "maybe" as part of a larger migration
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING