cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 upgrade to 10.5 on AIX

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

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
0 Kudos

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
Participant
0 Kudos

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

Answers (2)

Answers (2)

MarcinOzdzinski
Participant
0 Kudos

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

Former Member
0 Kudos

Thanks Marcin.

The approach suggested by you can be used as an fallback plan, if the direct restore into 10.5 fails.

But import/export activites would be only that suggested in the system copy guide which include license installation, Secure storage etc..

There won't be database relevant post installation activities except setting up the Database parameters as per the SAP note 1851832 for DB2 10.5 & activating Archive logs.

Please do correct me if I am wrong.

Regards,
Sagar

MarcinOzdzinski
Participant
0 Kudos

You can't restore BACKUP directly from 9.1 to 10.5 (only  to 9.1 , 9.5 and 9.7).

Import/export is fine but more time consuming and you can encounter more errors than in simple backup restore scenario.

Former Member
0 Kudos

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

former_member188883
Active Contributor
0 Kudos

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