Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    13

    Unanswered: backup and restore db from two different db2 version

    My question is : can i do the backup of db2 v8 database and restore to db2 v7 in the unix environment ..if yes where i can find some documentation ...

    thank ......

    Last edited by sosdb; 01-26-05 at 12:59.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    No .. you cannot .. you can do v7 to v8 and the process will migrate the catalog and all other structures to the latest version ,,
    But going from a higher version to lower is not supported (and doubt, will ever be supported)
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    sosdb,
    Because backup/restore to previous version is not supported, you will probably need to do something like this:
    1. db2look - to get database objects (primary keys, foreign keys, etc) run "db2look /?" for more help.
    2. export tables
    3. import or load tables

    Hope this helps,
    Grofaty

  4. #4
    Join Date
    Jan 2005
    Location
    Rio de Janeiro - Brazil
    Posts
    28

    Another option

    Another option for "restoring" the structure / data from this newer Database to a previous release would be the DB2MOVE feature.

    You can find it easily in the Command Reference how to use this tool.

    Hope this helps.

    Fernando
    Last edited by fohana; 01-27-05 at 16:50. Reason: posting more information

Posting Permissions

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