How long does it take to migrate db from 8.2 to 9.1 on LUW

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mark A
    #1

    How long does it take to migrate db from 8.2 to 9.1 on LUW

    When upgrading DB2 LUW from 8.2 to 9.1 the following command is issued as
    part of the upgrade:

    db2 migrate database <db-name>

    Does the migrate command make changes to every data and index page? Any
    estimate on how long it takes to run based on number of pages in the
    database?


    Tags: None
    • Ian
      #2
      Re: How long does it take to migrate db from 8.2 to 9.1 on LUW

      Mark A wrote:
      When upgrading DB2 LUW from 8.2 to 9.1 the following command is issued as
      part of the upgrade:
      >
      db2 migrate database <db-name>
      >
      Does the migrate command make changes to every data and index page? Any
      estimate on how long it takes to run based on number of pages in the
      database?
      >
      MIGRATE DATABASE changes the catalog, not individual data pages.

      As such, migrating a 4Mb SAMPLE database is generally not much different
      than migrating a 1Tb data mart. (In my experience).

        Comment

        Previous template Next
        Working...