Db2 On Premise and Cloud

 View Only
Expand all | Collapse all

DB2 direct upgrade from 9.7 to 11.5

  • 1.  DB2 direct upgrade from 9.7 to 11.5

    Posted Fri January 17, 2020 03:38 PM
    Edited by Anand Sagar Mon November 02, 2020 02:52 PM

    It is possible to upgrade directly 9.7 to 11.1 via an offline backup

    It is no longer possible to do this with 11.5. The error is:

    SQL2514N The RESTORE was not successful. The backup used to restore the database contained a database with a release number that is not compatible with the installed version of the database manager.

    We now need to do it in 2 steps via an intermediate version in-between. 

    9.7 -> 11.1 -> 11.5 works, for example

    Since there are no transaction log changes between 11.1 and 11.5, I don't know of a reason other than maybe to save some development/testing costs. Can someone provide insight on why we do have this restriction at all?

    Hung Tam Nguyen

    #Featured-area-3​  #Featured-area-3-home

  • 2.  RE: DB2 direct upgrade from 9.7 to 11.5

    Posted Mon January 20, 2020 01:52 AM
    Edited by Ian Oeschger Wed November 11, 2020 03:11 PM
    Hi Hung Tam,
    I completely agree with you, that you now have a tedious step inbetween.
    But on the other hand, DB2 9.7 came out in July 2009 and even end of support is more than two years ago. So IBM is just trying to cut the complexity of such a migration down to a neccessary part. In previous editions it was only possible to do and upgrade from two versions back. It was just for convenience that IBM allowed us to migrate from three levels down (9.7 -> 10.1 -> 10.5 -> 11.1).
    And don't forget, that such a migration is usually a big bang approach, as the client-server compatibility is just two levels down and one level up. So you also have to update your client code properly.


    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH