Migration from Oracle to DB2 UDB on Unix

[Former Member]

Hi SAP Expert

We have different SAP landscape in our company on Oracle DB

Due to High Oracle Licensing cost we are planning to migrate our Database to DB2 to reduce license cost

I would like to know how Reliable DB2 is for SAP? What is % of SAP installation on DB2 worldwide

Also will there be challenge migrating DB from Oracle to DB2

I would appreciate if you can provide guidance on the question

Thanks in advace

Thanks

Deelip

[StephenSun]

Hi Deelip,

Maybe below link can also somehow strengthen your confidence

http://www-03.ibm.com/press/us/en/pressrelease/32867.wss

Regards

[hans-juergen_zeltwanger]

Hello Deelip,

in addition to what Markus and Joachim already have posted:

I think we have documented the DB2 specifics of a migration quite well.

You can download the corresponding book free of charge here:

[IBM Redbook 'DB2 Optimization Techniques for SAP Database Migration And Unicode Conversion'|http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg247774.html]

Hans-Juergen

[Former Member]

Hello Deelip,

the last announcment from IBM:

http://it.toolbox.com/blogs/infosphere/ibm-migrates-700-sap-customers-from-oracle-to-db2-42108

http://www-05.ibm.com/eg/events/ibm_and_sap/pdf/DB2_Optimized_for_SAP.pdf

http://download.sap.com/solutions/business-suite/erp/customers/download.epd?context=6F19F9C312F55052...

You will find a lot of success stories in the www..

Best regards,

Joachim

[markus_doehr2]

> I would like to know how Reliable DB2 is for SAP? What is % of SAP installation on DB2 worldwide

DB2 was and is used on quite a number of internal SAP systems that create support packages (if you check the import logs of the support packages and search for "source system).

SAP doesn't give any exact numbers of installations compared to other databases, they did that in the past.

> Also will there be challenge migrating DB from Oracle to DB2

As with every database migration you'll have to check your custom programs and secondary indexes, backup strategies and methods and such.

> I would appreciate if you can provide guidance on the question

Be aware of the fact that you must have a certified migration consultant doing the migration on-site, otherwise SAP will deny OSS support and bill (see http://service.sap.com/osdbmigration).

Markus