472,989 Members | 2,890 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,989 software developers and data experts.

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
2 3147
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Ron Adam | last post by:
Hi, I'm having fun learning Python and want to say thanks to everyone here for a great programming language. Below is my first Python program (not my first program) and I'd apreciate any...
2
by: OakRogbak_erPine | last post by:
My company is considering purchasing MS SQL Server to run an application on (SASIxp). I am mainly familiar with Oracle, so I was wondering how long it would take to copy a database. Basically we...
0
by: xo55ox | last post by:
Hi, I have been trying to set up an automated restore process from prod to backup server. First, I schedule the full database backup nightly, transfer the backup file and restore it to the...
16
by: Justin Lazanowski | last post by:
Cross posting this question on the recommendation of an I have a .NET application that I am developing in C# I am loading information in from a dataset, and then pushing the dataset to a grid,...
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following SQL2059W A device full warning was...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
2
by: celsius | last post by:
Hi folks, Al Bowers wrote this program on comp.lang.c Date: 2001-07-09 13:41:58 PST #include <stdio.h> int isleap (unsigned yr); static unsigned months_to_days (unsigned month); static long...
3
by: Paul Aspinall | last post by:
Hi Can anyone recommend a suitable way of calculating distances between UK post codes?? Many websites do this, and I'm wondering if there is some standard code, and where the reference DB comes...
4
by: =?Utf-8?B?TmF2YW5lZXRoLksuTg==?= | last post by:
Say I have a class like, class Sample { public decimal first = 10; public decimal second = 20; } I have initialized it
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.