Skip to Content
author's profile photo Former Member
Former Member

Migration from Oracle to DB2 UDB on Unix

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 10, 2010 at 09:24 AM

    > 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2010 at 09:40 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 10, 2010 at 10:13 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2010 at 08:17 PM

    Hi Deelip,

    Maybe below link can also somehow strengthen your confidence

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

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.