My 2 cents...
On the outside chance that you migrated from Db2 v8 to v9, you really should rebuild the database from scratch because the tablespace structures changed dramatically.
Otherwise, I would suggest upgrading to v10.5, then v11.5. I've don't the database rebuild from scratch (v9.7 to v10.5 and using data replication between servers) and it can be a real pain if you don't have a simple database setup.
------------------------------
Douglas Kostelnik
------------------------------
Original Message:
Sent: Fri June 28, 2024 03:55 AM
From: Damir Wilder
Subject: DB2 v9.7 restore to DB v11.5
Hi,
You should be able to download DB2 v10.5 (or v11.1) from the IBM Fix Central and install it with the 90-day trial licence (as there is no Community Edition for those older versions). That should give you more than enough time for the upgrade to v11.5.
Hope that works for you.
------------------------------
Damir Wilder
Original Message:
Sent: Thu June 27, 2024 02:59 AM
From: sruthin tk
Subject: DB2 v9.7 restore to DB v11.5
When I attempted to restore a DB2 9.7 backup image to DB2 v11.5 Community Edition, I encountered an error.
"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."
I understand that I can't directly restore it to version 11.5. I have to upgrade it to an intermediate version. How can I download version DB2 11.1?Or is there any other way to do it?
------------------------------
sruthin tk
------------------------------