471,863 Members | 1,117 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,863 software developers and data experts.

Minimum Recovery time on tablespace

On my DB2/UDB system, some tablespace 'Minimum recovery time' is
2000-11-19 or some '1999-10-04' or different, for some tablespace
theres is no 'Minimum recovery time' , what does it tell me?

Thanks,
VKG
Nov 12 '05 #1
1 4414
Vikrant wrote:
On my DB2/UDB system, some tablespace 'Minimum recovery time' is
2000-11-19 or some '1999-10-04' or different, for some tablespace
theres is no 'Minimum recovery time' , what does it tell me?

Thanks,
VKG


It tells you the minimum time to rollforward this tablespace
during tablespace recovery.

The minimum recovery time guarantees that after a point-in-time
restore of this tablespace it will be in sync with the
syscatspace.
Creating tables, dropping tables or altering tables for
example will set the minimum recovery time on a tablespace
or altering some characteristic of the tablespace itself will
also set this time.

The minimum recovery time is not set for the syscatspace
(because you can't recover this tablespace to a point-in-time)
or for temporary tablespaces. It might also not be set because
you never changed the definition of a table (create/alter/drop)
or of this tablespace.

HTH.

Best regards

Eric
--
IT-Consulting Herber
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Neil Truby | last post: by
10 posts views Thread by xixi | last post: by
reply views Thread by db2sysc | last post: by
2 posts views Thread by Raghava | last post: by
3 posts views Thread by rdudejr | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.