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

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.

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