467,175 Members | 1,249 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,175 developers. It's quick & easy.

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

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.
Nov 12 '05 #1
  • viewed: 3028
Share:
2 Replies
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! =-----
Nov 12 '05 #2
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! =-----

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by OakRogbak_erPine@yahoo.com Kill the 2 trees in e | last post: by
16 posts views Thread by Justin Lazanowski | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
3 posts views Thread by Paul Aspinall | last post: by
4 posts views Thread by =?Utf-8?B?TmF2YW5lZXRoLksuTg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.