Results 1 to 10 of 10
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: redirected restore question

    I am planning to perform a database clone copy move from our old server to the new database server. How would I perform a redirected restore from serverA to serverB or is there a better method to do this? This will be part of the server move and database migration from old hardware using DB2 7.2 on AIX 5.2 to new RS6000 hardware and a database upgrade to 8.1.2 DB2 UDB on AIX 5.2.

    Steps planned:
    1. install and configure DB2 UDB 8.1.2 on new hardware

    2. migrate existing DB2 database instance and databases to over to new database server

    3. perform database upgrade/migration

    Thanks

    Scott

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    If you dont have any other database objects that may have to be migrated then export the data in del format and import it back on the new database which was set up in V8.
    or

    Install v7 on your new hardware and do the redirected restore and migrate the instance and apply the fixpacks upto 3

  3. #3
    Join Date
    May 2003
    Posts
    369

    upgrade and db2 move

    So should I install DB2 7.2 first before loading DB2 8.1.2 on the new server hardware? Is it possible to load data from V7.2 UDB into DB2 UDB 8.12? Thanks!

  4. #4
    Join Date
    Dec 2002
    Posts
    134

    Re: redirected restore question

    I suggest
    1. Take v7 backup (old box)
    2. Restore v7 backup on v8 (new box). During restore automatic db migration will be done


    There is not need for v7 install on a new box

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    However, there is something about indexes - if I recall correctly, if you restore a v7 backup to v8 and wish to benefit from the v8 type 2 indexes then you will have to drop and recreate all indexes.

    Another thing that comes to mind is that if you have data fragmentation, you can take this opportunity to remove it by export-load though ofcourse, it will be a slower process. There are other challenges to using this method if the system is MPP.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    In DB2 V8, REORG INDEXES will always convert type-1 indexes to
    type-2 indexes unless you are using the CLEANUP option.

  7. #7
    Join Date
    Mar 2003
    Posts
    343
    But won't a drop and create be faster?

  8. #8
    Join Date
    May 2003
    Posts
    369

    restore and upgrade

    Great thanks here is what I have thus far:

    1. Install DB2 UDB V8.1.2 on new server
    2. Extract DDL from old database server (use db2look)
    3. Create database on new server with ddl
    4. Restore old database v7.2 to new database server
    5. Test to see if all works.

  9. #9
    Join Date
    Dec 2002
    Posts
    134

    Re: restore and upgrade

    Originally posted by mixxalot
    Great thanks here is what I have thus far:

    1. Install DB2 UDB V8.1.2 on new server
    2. Extract DDL from old database server (use db2look)
    3. Create database on new server with ddl
    4. Restore old database v7.2 to new database server
    5. Test to see if all works.
    I do not understand why you need steps 2. DB backup contains all required ddls. The only thing you need to do is redirect containers during restore.

    -dmitri

  10. #10
    Join Date
    May 2003
    Posts
    369

    thanks good point

    I agree. I was thinking of disk and filesystem layout which I will need with the DB2 installation anyhow. Thanks again.

    Scott

Posting Permissions

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