Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:25 PM

    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


  • 2.  RE: Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:25 PM

    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.




  • 3.  RE: Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:27 PM
    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.


  • 4.  RE: Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:27 PM

    Minimum required starting release is DB2 V10.5FP7 (or DB2 V10.5FP7SAP). There will be no improvement in earlier releases.




  • 5.  RE: Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:27 PM

    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




  • 6.  RE: Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:27 PM

    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




  • 7.  RE: Completing database version upgrade with minimal downtime

    Posted Wed March 31, 2021 12:28 PM
    Hi. The latest drop s1602242100 has the ability to do HADR upgrade and rollforward through database upgrade (aka avoid offline backup during upgrade process).