RTS reset by Recovery

Peter Adlersburg

RTS reset by Recovery
Dear DB2-colleagues,

I'm talking DB2 V8. Recently I noticed that doing a RECOVER TORBA or
TOCOPY resets all Realtime-Statistics for the recovered tablespace. This may
seem trivial if you only recover one ts, but becomes pretty unhandy if you
reset the entire set of tablespaces (hundreds of them) of any application. Are
there any possibilities to avoid the resetting?

kind regards,

peter

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Michael Ebert

Re: RTS reset by Recovery
(in response to Peter Adlersburg)
DB2 cannot know the value for the statistics that were valid at the PiT
you're recovering to, so there's no choice but to reset them.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




Peter Adlersburg <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
[DB2-L] RTS reset by Recovery





Peter Adlersburg <[login to unmask email]>
Please respond to : DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
13-01-09 10:18


Dear DB2-colleagues,

I'm talking DB2 V8. Recently I noticed that doing a RECOVER TORBA or
TOCOPY resets all Realtime-Statistics for the recovered tablespace. This
may
seem trivial if you only recover one ts, but becomes pretty unhandy if you

reset the entire set of tablespaces (hundreds of them) of any application.
Are
there any possibilities to avoid the resetting?

kind regards,

peter

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html





IMPORTANT - CONFIDENTIALITY NOTICE - This e-mail is intended only for
the use of the individual or entity shown above as addressees. It may
contain information which is privileged, confidential or otherwise
protected from disclosure under applicable laws. If the reader of this
transmission is not the intended recipient, you are hereby notified that
any dissemination, printing, distribution, copying, disclosure or the
taking of any action in reliance on the contents of this information is
strictly prohibited. If you have received this transmission in error,
please immediately notify us by reply e-mail or using the address below
and delete the message and any attachments from your system.

Amadeus Data Processing GmbH
Geschäftsführer: Eberhard Haag
Sitz der Gesellschaft: Erding
HR München 48 199
Berghamer Strasse 6
85435 Erding
Germany

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Mark Labby

Re: RTS reset by Recovery
(in response to Michael Ebert)

We hit this too and decided that for our Disaster Recovery, where we are set to recover tens of thousands of objects, reorging to get RTS back is totally impractical.  What we are planning to do is:
  • Recover the RTS database in one of the first groups of items recovered to the system quiesce.  
  • Extract the values from RTS for each of our client region sets of tables (approximately 2000 objects with the tables and indices) - for us it will be done using a Princeton Softech extract for each set.  
  • Recover each client to the same RBA as we did the catalog and RTS table, then update RTS for that client from the extract.  Since it was from the same RBA, theoretically I think we should be spot on.

When doing a recover in a test region, they typically are going back to a week old backup and we do not have the RTS from that same point.  They would typically only be recovering one set of the tables, not everything in the subsystem, so we would not want to recover the RTS tablespaces.  So what we do is grab the current RTS values for those tables, do the recovery, and then update the RTS to what it was before the recover.  We recognize that the values won't match the data, but in a test region that is 'close enough' and can do a reorg to get things right sometime over the weekend or as time permits.

Hope this helps...

Mark Labby

Senior Database Administrator
American Education Services/PHEAA
717-720-2731 -- [login to unmask email]
IBM Certified Database Administrator, DB2 UDB v8.1 for z/OS

IDUG Web Committee Chair 2008-2009
www.IDUG.org



"Peter Adlersburg" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>

01/13/2009 04:18 AM

Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>

To
[login to unmask email]
cc
Subject
RTS reset by Recovery





Dear DB2-colleagues,

I'm talking DB2 V8. Recently I noticed that doing a RECOVER TORBA or
TOCOPY resets all Realtime-Statistics for the recovered tablespace. This may
seem trivial if you only recover one ts, but becomes pretty unhandy if you
reset the entire set of tablespaces (hundreds of them) of any application. Are
there any possibilities to avoid the resetting?

kind regards,

peter

===== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. =====

IDUG 2009 - Europe * 5-9 October * Rome, Italy

IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.