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.  DB2 v9.7 restore to DB v11.5

    Posted Thu June 27, 2024 09:34 AM

    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
    ------------------------------


  • 2.  RE: DB2 v9.7 restore to DB v11.5

    Posted Thu June 27, 2024 10:26 AM
    1. V9.7 -> V10.5  (Backup/Restore);
    2. V10.5 -> V11.5 (backup/restore)

    or:

    1. Unload data from V9.7 (export or db2move);
    2. Run db2look to create script to re-create all db2 objects;
    3. run a/m script in V11.5 to create database and all objects;
    4. reload all data (import or LOAD).



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


  • 3.  RE: DB2 v9.7 restore to DB v11.5

    Posted Fri June 28, 2024 02:08 AM

    Try looking at Db2  load cusor , by connecting cursor remotely.  Remember to reset any sequence, indenity columns , etc

    Brian 



    ------------------------------
    Brian Walker
    ------------------------------

    Original Message


  • 4.  RE: DB2 v9.7 restore to DB v11.5

    Posted Fri June 28, 2024 03:55 AM

    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


  • 5.  RE: DB2 v9.7 restore to DB v11.5

    Posted Mon July 01, 2024 02:33 AM

    @Damir Wilder
    How we get the trail licene?



    ------------------------------
    sruthin tk
    ------------------------------

    Original Message


  • 6.  RE: DB2 v9.7 restore to DB v11.5

    Posted Mon July 01, 2024 02:45 AM

    When you download Db2 V10.5 or V11.1 from  Fix Central - it comes with trial license for 90 days.



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


  • 7.  RE: DB2 v9.7 restore to DB v11.5

    Posted Mon July 01, 2024 09:14 AM

    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


  • 8.  RE: DB2 v9.7 restore to DB v11.5

    Posted Mon July 01, 2024 10:00 AM

    Actually - adding my 0.02 $ CAD - most of the time (unless migrating from V11.x to V11.y (x <y)) - I would recommend rebuilding database(s) - one can catch some old artifacts no longer needed and review authorization/privileges to conform to current company security requirements ...



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message