Skip to Content
avatar image
Former Member

Migrate from DB2 to Oracle

Hi Experts,

I have inquiry regarding down time when doing db2 migration from DB2 to Oracle. How long do we need to spend down time. If you have any experience or information regarding this, please let us know.

Thanks & Regards,

Rudi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 21, 2009 at 11:20 AM

    Nobody will be able to answer that question.

    It depends:

    - of the speed of the I/O subsystem

    - the number of parallel R3load processes you use

    - the number of processors in both source and target system

    - splitting of the tables or no splitting - and how

    You can check what I wrote in thread

    OS/DB Migration from Windows to Solaris

    to get an avg. overview of how this can be done.

    As already said, you need to have a certified migration consultant on-site to do the migration, otherwise you will loose support for the target system.

    Check http://service.sap.com/osdbmigration

    --> FAQ

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21, 2009 at 05:56 AM

    Hi Rudi,

    Question asked by you is very difficult to answer for any technical guy.

    Its all depend on the database size and hardware you are using for the migration you can not predict downtime for your mnigration based on the other migration.

    Suggestion would be perform the test migtation first on your system so that you will get an idea how much downtime you will need for your sysyem when you will pefrom actual migration.

    let me know if you have any other questions.

    Regards, AG

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Atil,

      I read from oracle official docs, they said that they can predict the downtime. Our db size is about 3TB using AIX 5.3 on P5 machine.

      Regards,

      Rudi

  • avatar image
    Former Member
    Jan 21, 2009 at 10:24 AM

    This activity must be performed by DB certified consultants from SAP. ot i think SAP will not support in case of any issues

    Add comment
    10|10000 characters needed characters exceeded