measure recovery time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yasaswi Pulavarti - 30 Nov 2004 15:43 GMT

Just by knowing the size of the datafiles of a database, how can I
make an estimate of the recovery time. I have have a backup file, does
db2ckbkp have a switch to tell me the estimated recovery time without
actually recovering the database?
Thanks,
Yasaswi Pulavarti

Reply to this Message

dotyet - 30 Nov 2004 23:24 GMT

it should depend on a lot of things besides your backup image size:

your backup frequencies
your number and size of archive logs needing rollforward
your machines IO/CPU/Memory etc.

i have not heard about any such command or utility or switch. maybe
someone else can shed more light on this.

hth,
dotyet

> Just by knowing the size of the datafiles of a database, how can I
> make an estimate of the recovery time. I have have a backup file, does
> db2ckbkp have a switch to tell me the estimated recovery time without
> actually recovering the database?
> Thanks,
> Yasaswi Pulavarti

Reply to this Message