DB2 UDB v8 on Aix 5.2. Calculating how long to restore?

[dba2adm]

I have a restore (redirected) job running for about an hour. Is there
any way, to identify how long the restore will take? I have a few
hundred containers totaling couple of 100G to restore.

I don't see the containers being restored in any order, so its hard to
calculate based on that info. I am looking the last accessed files
from unix (ls -lt).

Thanks,
DA.

[Ian]

db*****@yahoo.com wrote:

I have a restore (redirected) job running for about an hour. Is there
any way, to identify how long the restore will take? I have a few
hundred containers totaling couple of 100G to restore.

I don't see the containers being restored in any order, so its hard to
calculate based on that info. I am looking the last accessed files
from unix (ls -lt).

If you look at the IO throughput going to your disks, you can come up
with a pretty decent estimate for how long it will take (provided you
know how big the backup is).

Keep in mind that with DMS file containers, the first step in a
redirected restore is to create the new file containers. For a
100 Gb database this should not be too bad, but for very large
databases on RAID5 arrays this can sometimes take a while.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[dba2adm]

Thanks Ian.

I had only the compressed backup (approx 25+G). I had to uncompress
this to a pipe and do the redirected restore.

The set containers took around 2.5hrs. Disk system EMC RAID 5. From
the set containers, I can calculate the rough size. What is the
better way to calculate the total backup size?

Now, assuming I calculated the total backup size, is there any other
tool other than "iostat" (using the io throughput) to calculate the
progress of the restore?

Thanks,
da.

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...

db*****@yahoo.com wrote:

I have a restore (redirected) job running for about an hour. Is there
any way, to identify how long the restore will take? I have a few
hundred containers totaling couple of 100G to restore.

I don't see the containers being restored in any order, so its hard to
calculate based on that info. I am looking the last accessed files
from unix (ls -lt).

If you look at the IO throughput going to your disks, you can come up
with a pretty decent estimate for how long it will take (provided you
know how big the backup is).

Keep in mind that with DMS file containers, the first step in a
redirected restore is to create the new file containers. For a
100 Gb database this should not be too bad, but for very large
databases on RAID5 arrays this can sometimes take a while.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----