DB2 upgrade to 10.5 on AIX

[Former Member]

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

[former_member188883 · Accepted solution]

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

[Former Member · Accepted solution]

Thank you Deepak.

I feel the first option should work fine.

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

[MarcinOzdzinski · Accepted solution]

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).