Changes with DB2 version 9 and automatic tablespaces / restore / listutilities

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

    Changes with DB2 version 9 and automatic tablespaces / restore / listutilities


    I am restoring a database (approximately 1 Terabyte). After the
    restore started, I noticed that the "list utilities" completed work
    was not being updated. I checked the location of the restore and
    watch to see that the size of the table spaces was increasing.

    Once the table spaces were about done then I saw list utilities
    "completed work" began increasing. What exactly is the restore
    doing? Is this expected?

    It seems that it would be best to have the "completed work" in db2
    list utilities to keep counting up.

    Thanks,

    -Kevin
    Tags: None
    • Ian
      #2
      Re: Changes with DB2 version 9 and automatic tablespaces / restore/ list utilities

      Justin wrote:
      I am restoring a database (approximately 1 Terabyte). After the
      restore started, I noticed that the "list utilities" completed work
      was not being updated. I checked the location of the restore and
      watch to see that the size of the table spaces was increasing.
      >
      Once the table spaces were about done then I saw list utilities
      "completed work" began increasing. What exactly is the restore
      doing? Is this expected?
      Yes. DB2 is allocating the tablespace containers (i.e. the equivalent
      to what happens when you create a new tablespace). With very large
      tablespaces, this can take quite some time.
      It seems that it would be best to have the "completed work" in db2
      list utilities to keep counting up.
      Not really. Completed work involves writing the data from the backup
      image into the tablespaces.


        Comment

        Previous template Next
        Working...