Skip to Content
avatar image
Former Member

DB2 upgrade to 10.5 on AIX

Hello Guys,

We are currently on ECC 6,0 SP27 and Kernel 700 with DB2 Database 9.1

We are planning to upgrade to ECC 6.0 EHP7 & Database to 10.5

We are planning to do a system copy from existing landscape (DB2 9.1) & while installing Target system, instead of providing DB2 Database 9.1 (same as source) we would give path of DB2 database 10.5 & also kernel 720.

After the system copy, we will upgrading the ECC 6.0 environment to EHP7.

Will this work ?

Regards,

Sagar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 29, 2014 at 09:50 AM

    Hi Sagar,

    For performing system copy using export/import, below are high level activities

    For detailed activities you need to refer system copy guide from SAP service marketplace.

    1) Prepare your target system hardware along with file system and other pre-requisites

    2) Install target system with db2 10.5 using system copy option.

    3) Perform db export of source database using SWPM

    4) Perform db import into target system with db2 10.5.

    5) Perform post import activities

    6) Perform SAP upgrade to EHP7 as desired

    Note: Check PAM for OS/DB compatibility with eHP7 for your target environment.

    For Backup/ restore method, you can go with below procedure. I have not worked on with this option so not very sure about required steps and whether it will really work or not.

    1) Perform backup of database from source system including logs

    2)  Install target system with db2 10.5

    3)  Restore backup of source to target 10.5. Perform db upgrade steps ( like we do it in oracle)

    4) Perform post copy steps

    5) Proceed with SAP version upgrade to EHP7 as desired.

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • 1) Perform backup of database from source system including logs

      2)  Install target system with db2 10.5

      3)  Restore backup of source to target 10.5. Perform db upgrade steps ( like we do it in oracle)

      4) Perform post copy steps

      5) Proceed with SAP version upgrade to EHP7 as desired.

      You can't restore backup from 9.1 into 10.5 (it is possible up to two major releases) so you must restore it into 9.7 and then make db upgrade to 10.5 (better after upgrading sap to Ehp7 cause pure ECC 6.0 with low SP is not supporting all 10.5 functions and is not compatible with newer database collector functions - it will work but you will have lot of db errors in SM21).

  • Dec 29, 2014 at 10:39 AM

    Easier approach without import/export activities.

    Perform system copy using SWPM and use 9.7 latest fixpack as target database.

    Restore your 9.1 offline backup into 9.7

    Upgrade your SAP to Ehp7

    Upgrade your DB to 10.5

    Regards

    Marcin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Marcin Ozdzinski

      Yes, you are correct.

      Export/ Import would be preferred.

      Time is not a constraint for us.

      If there are lot of errors, we can follow your suggestion of restoring into 9.7

      Thanks

      Sagar

  • Dec 29, 2014 at 09:03 AM

    Hi Sagar,

    We are planning to do a system copy from existing landscape (DB2 9.1) & while installing Target system, instead of providing DB2 Database 9.1 (same as source) we would give path of DB2 database 10.5 & also kernel 720.

    IF you use database export/import for homogenous system copy it should work.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded