Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2014
    Posts
    8

    Unanswered: Restoring the DB2 Databases to a lower version

    Hi,

    I have taken a backup of DB2 databases using the command from version 10.1 and when tried to restore the same on to a lower version of DB2 9.7 it did not work.

    BACKUP DATABASE RAMDB TO "D:\Software"

    Want to know if this backward restore capability is supported in DB2 or not.

    Error I got is

    " E:\db_backup>db2 restore database RTCDB taken at 20141111040046
    SQL2542N No match for a database image file was found based on the source
    database alias "RTCDB" and timestamp "20141111040046" provided.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    DB2 does not support restoring a backup-image to a *lower* db2-version.
    This information appears in the on-line Knowledge-Centre.
    DB2 supports restoring a backup-image to a same-or-higher db2-version (typically 2 versions above).
    To achieve what you want, you can use ETL or export/load with db2look+db2move. Refer to the on-line knowledge centre for details.

  3. #3
    Join Date
    Nov 2004
    Posts
    67
    Even if versions were equal it would not work because you backup to D:\Software and do restore from E:\db_backup.
    You don't have to specify backup timestamp if you have only one backup image in D:\Software.
    If you are on E:\db_backup you can use "db2 restore database RTCDB from D:\Software".

    If you change to D:\Software, you can write:
    "db2 restore database RTCDB"

  4. #4
    Join Date
    Nov 2004
    Posts
    67
    Even if versions were equal it would not work because you backup to D:\Software and do restore from E:\db_backup.
    You don't have to specify backup timestamp if you have only one backup image in D:\Software.
    If you are on E:\db_backup you can use "db2 restore database RTCDB from D:\Software".

    If you change to D:\Software, you can write:
    "db2 restore database RTCDB"

  5. #5
    Join Date
    Nov 2004
    Posts
    67
    Oops. Sorry for double posting.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •