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 System Fri January 20, 2023 04:42 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

    ​​  ​

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

    IBM Champion
    Posted Mon January 20, 2020 01:52 AM
    Edited by System Fri January 20, 2023 04: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