Hi. The latest drop s1602242100 has the ability to do HADR upgrade and rollforward through database upgrade (aka avoid offline backup during upgrade process).
Original Message:
Sent: Mon March 30, 2020 10:51 AM
From: ROBBY SHARMA
Subject: Completing database version upgrade with minimal downtime
Need to check, why there was no announcement on SCN.
SAP Note 101809 is up to date:
http://service.sap.com/sap/support/notes/101809
Original Message:
Sent: Mon March 30, 2020 10:51 AM
From: ROBBY SHARMA
Subject: Completing database version upgrade with minimal downtime
Thanks again, Jens - this is really useful upgrade-related information but there isn't any official announcement about that functionality yet on the db2 10.5 fixpack 7 release notes or sap community website [even though it has been certified by sap 3 weeks ago]:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.wn.doc/doc/c0061179.html?lang=en-us#c0061179__fp7_desc
http://scn.sap.com/community/db2-for-linux-unix-windows
Original Message:
Sent: Mon March 30, 2020 10:51 AM
From: ROBBY SHARMA
Subject: Completing database version upgrade with minimal downtime
Minimum required starting release is DB2 V10.5FP7 (or DB2 V10.5FP7SAP). There will be no improvement in earlier releases.
Original Message:
Sent: Mon March 30, 2020 10:51 AM
From: ROBBY SHARMA
Subject: Completing database version upgrade with minimal downtime
Thanks, Jens - please let us know if there is a plan to include this capability like for upgrading db2 9.7 to db2 10.5 fixpack 7 special build certified by sap with this minimal downtime or will it be applicable only to db2 10.5 fixpack 7 special build certified by sap -> vnext going forward.
Original Message:
Sent: Mon March 30, 2020 10:50 AM
From: ROBBY SHARMA
Subject: Completing database version upgrade with minimal downtime
There is work in progress to reduce downtime.
The intend is that DB upgrade becomes recoverable (consists of fully logged operations only). As a consequence,
- no offline backup is required before upgrade, a online backup or snapshot backup is enough.
- DB upgrade gets performed on HADR standby as well by log record shipping (no need to re-establish HADR standby after DB upgrade)
This should minimize the required downtime dramatically from hours to less than a hour.
In downtime problematic setups, you for sure should still perform a test upgrade on a database clone first.
To my knowledge you need V10.5 FP7 as basis for this minimized downtime upgrade.
Original Message:
Sent: Mon March 30, 2020 10:49 AM
From: ROBBY SHARMA
Subject: Completing database version upgrade with minimal downtime
We continue to struggle with obtaining downtime - more so in a sap environment where some post-processing steps need to be done after database version upgrade.
Currently, only rolling fixpack upgrades are allowed with db2 hadr - will it be possible to complete database version upgrade with minimal downtime using core db2 functionality in this forthcoming new release?
Thank you.
#Db2
#Db2EarlyAccessProgram(EAP)Forum