Mark,

Actually it's not confusing.  Logically since there have been no
transactions between the two full DBB, resetting the recovery log should not
logically cause any problems.  Of course if TSM is marking each DBB and
recovery log set with some sort of serial number, and will only play with
matching serial numbers I can understand the "mechanical" reason why it
won't work.

Of course I can have my cake and eat it too by:
1) Doing a full DBB to disk
2) Sending that DBB to tape during my daily Sysback system backup

Thanks,
H. Milton Johnson
Voice: (210) 677-6728

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mark D. Rodriguez
Sent: Tuesday, February 17, 2004 1:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Question on Restoration from DBSNAPSHOT

Milton,

The short answer is no.  You can only use the most recent full/incremental
series to restore to the most current state, i.e. using the ROLLFORWARD log.
The reason is that once you do a DBB (either full or incremental) the log is
reset.  Therefore any older version, in your case the first DBB full, can
only be used for a PIT restore.

Hang in there, I know it gets confusing at times but it really does make
sense in a crazy sort of way!

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

============================================================================
===
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced
Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP,
TSM/ADSM and Linux Red Hat Certified Engineer, RHCE
============================================================================
===



Johnson, Milton [IT] wrote:

>Mark / Mike,
>
>Nice to here from you Mark.  I am aware that DBSNAPSHOT can only be
>used for PIT restoration, at least after refreshing myself, and that
>only the BACKUP DB FULL/INCR resets the recovery log. What I'm now
>asking is can I make two DBB (full), one immediately after the other,
>and then use either one to do a restore to the point of failure using the
recovery log?
>
>Thanks,
>H. Milton Johnson
>Voice: (210) 677-6728
>
>