Skip to Content
avatar image
Former Member

Restoration offline backup of DB2 9.7.3 to DB2 9.7.7

Dear Team,

Is it possible to restore Offline backup of DB2 9.7.3 to DB2 9.7.7? Is there any issue being observed of doing so?

Thanks

Mehul

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 17, 2014 at 07:19 AM

    Hi Mehul,

    As there is only a fix pack difference, I do not see any major hiccups in restoring 9.7.3 to 9.7.7 database using offline backup.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      reverting a fixpack may cause problems since new fixpacks may update table functions in the system catalog ( db2updv97 ).

      After restoring a V9.7 FP3 Backup with V9.7 FP7 software you should run db6_update_db for the same reason. db6_update_db wil call db2updv97 and this may update table functions in the system catalog.

      select * from sysibm.sysversions

      to get a history of DB2 sofware versions used with your database.

      Regards

      Frank