Recovery: DSNUTILB VS DSN1COPY

Srinivas Nandigam

Recovery: DSNUTILB VS DSN1COPY
Listers,
We have a recovery requirement where we have a full
image copy for the database. We have both the options
of recovering the database with recovery utility and
DSN1COPY. I request your help in understanding the
best way to do considering the CPU time. Please let me
know If there are any major differences.

Thanks,
Srinivas

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com



James Campbell

Re: Recovery: DSNUTILB VS DSN1COPY
(in response to Srinivas Nandigam)
Is there more than one tablespace that must be recovered in sync
(eg an RI relationship between the two). Could they have been
updated during the image copy process. Again, DSN1COPY will
not ensure that they are consistant.

All in all, a DSN1COPY recovery (from an image copy) is only valid
if no changes were made to any of the recovered tablespaces from
when the first image copy started to when the last image copy
finished. If you can guarantee that, DSN1COPY recovery is fine; if
not you must use RECOVER.

James Campbell

On 21 Dec 2001, at 6:37, Srinivas wrote:

Date sent: Fri, 21 Dec 2001 06:37:27 -0800
Send reply to: DB2 Data Base Discussion List <[login to unmask email]>
From: Srinivas <[login to unmask email]>
Subject: [DB2-L] Recovery: DSNUTILB VS DSN1COPY
To: [login to unmask email]

> Listers,
> We have a recovery requirement where we have a full
> image copy for the database. We have both the options
> of recovering the database with recovery utility and
> DSN1COPY. I request your help in understanding the
> best way to do considering the CPU time. Please let me
> know If there are any major differences.
>
> Thanks,
> Srinivas
>
James A Campbell