db2 – Downgrade of upgraded instance and database?

All we need is an easy explanation of the problem, so here it is.

So far I have always "upgraded" database using clean install (new Linux install etc) inside virtual machine.

But now I have requirement to upgrade Db2/Linux from Db2 v11.1 to Db2 v11.5 installed on physical machine (not virtual machine).

Existing instance Db2 v11.1 is installed on the machine.

  1. During installation I have got error about incompatible libraries, so it was forced to use db2rmln command to remove Linux links to libraries.
  2. After install it was required to upgrade (not update!) instance and I did it with: ./db2iupgrade
  3. Then migrate database.

I am just wondering in case of some bad luck. Is it possible to downgrade the instance and database from V11.5 to V11.1? Is downgrading supported between two Db2 releases?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

No, downgrading databases is not supported. Save the pre-upgrade backup and installation media if you want to go back. Obviously, you will lose all data modified since the upgrade.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply