Re: SNAPSHOT - recovery options

Leslie Pendlebury-Bowe

Re: SNAPSHOT - recovery options
(in response to Adrian Savory)
Adrian

I can tell you this ..

in about 2/3 years time .. and that is assuming it gets pushed up the
priority list in IBM ...

Also I think somebody on here did the LOGONLY stuff or was looking
into it about two months ago .. have a look in the archives as I am
sure this subject has been chewed over.

anyway I thought you had to take 2 weeks off work over Christmas ...
:-)

Leslie Pendlebury-Bowe


______________________________ Reply Separator _________________________________
Subject: SNAPSHOT - recovery options
Author: Adrian Savory <[login to unmask email]> at Internet
Date: 12/30/99 11:51 AM


Hi folks,

Can any IBMer (or anyone else) tell me if (when?) the DB2 Recover utility will
support SNAPSHOT in future i.e. snap back virtual concurrent copy backups,
rather than recover them at the usual speed?

What I'm looking for is a fast AND flexible method of recovering a large number
of DB2 objects, some of which will be big. SNAPSHOT looks to be the way forward,
but I need fast recovery. The only way I think I can get that at the moment is
by taking offline DFDSS dumps (via SNAPSHOT) and restoring them (snapping them
back), but this isn't flexible enough as I only have the one recovery point that
I can recover to quickly. (Incidentally has anyone played about with using
SNAPSHOT to recover snapped backups, followed by a LOGONLY recovery to a
point-in-time? Does this work? Any gotchas?)

Also, are there any plans for SNAPSHOT to be embedded in any other utilities in
future? e.g. UNLOAD, REORG, etc.

Thanks.

Adrian Savory
ACSIS Ltd








Adrian Savory

SNAPSHOT - recovery options
Hi folks,

Can any IBMer (or anyone else) tell me if (when?) the DB2 Recover utility will
support SNAPSHOT in future i.e. snap back virtual concurrent copy backups,
rather than recover them at the usual speed?

What I'm looking for is a fast AND flexible method of recovering a large number
of DB2 objects, some of which will be big. SNAPSHOT looks to be the way forward,
but I need fast recovery. The only way I think I can get that at the moment is
by taking offline DFDSS dumps (via SNAPSHOT) and restoring them (snapping them
back), but this isn't flexible enough as I only have the one recovery point that
I can recover to quickly. (Incidentally has anyone played about with using
SNAPSHOT to recover snapped backups, followed by a LOGONLY recovery to a
point-in-time? Does this work? Any gotchas?)

Also, are there any plans for SNAPSHOT to be embedded in any other utilities in
future? e.g. UNLOAD, REORG, etc.

Thanks.

Adrian Savory
ACSIS Ltd