OnDemand User Group

Support Forums => MP Server => Topic started by: Neosta on July 10, 2019, 03:58:16 AM

Title: Database Migration
Post by: Neosta 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.

Title: Re: Database Migration
Post by: jsquizz 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..)

Title: Re: Database Migration
Post by: Justin Derrick 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.

Title: Re: Database Migration
Post by: jsquizz on July 10, 2019, 02:36:09 PM

Quote from: Justin Derrick 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.

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