Check out the referenced web page
http://www-3.ibm.com/software/data/db2imstools/db2tools/db2recovexpert.html
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
"John Spiewak"
<jspiewak@tradepo
wer.com> To
Sent by: Dale McInnis/Toronto/IBM@IBMCA, "'r
owner-db2eug@Lugw x'" <[EMAIL PROTECTED]>
ash.org cc
<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
01/09/2003 09:34 Subject
AM RE: [DB2EUG] Recovery of single
table to point in time
Please respond to
"John Spiewak"
<jspiewak@tradepo
wer.com>
I am having trouble finding information on the IBM Data Management
Recovery Expert utility. Is it available on AIX and if so what version
of UDB?
Thanks
John Spiewak
R & D Consultant / Database Engineer
TradePower
(215) 542-8300 X 1-5774
(800) 289-8771
[EMAIL PROTECTED]
www.tradepower.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 7:41 AM
To: r x
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [DB2EUG] Recovery of single table to point in time
Ravi
a) The minimum rollforward PIT will be the last DDL statement for that
tablespace OR the last update that affected a table in the tablespace
being restored as well as a table in a tablespace that was NOT restored.
If your tablespace is self contained, e.g. the indexes and LOBs are in
the same tablespace and the modifications did not trigger any other
tables to be updated through a cascading delete or trigger then you will
be OK. I am assuming you are on a EE instance, there are a different
set of rules for EEE.
b) To recovery on a single table within a tablespace take a look at the
IBM Data Management Recovery Expert utility.
Hope this helps.
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
r x
<dbadb2udb@yahoo.
com>
To
Sent by: [EMAIL PROTECTED]
owner-db2eug@Lugw
cc
ash.org
Subject
[DB2EUG] Recovery of single table
01/09/2003 01:03 to point in time
AM
Please respond to
r x
<dbadb2udb@yahoo.
com>
Hi List,
Problem with recovery.
DB2 V7.2 AIX
We are trying to formulate a recovery strategy for our
shop.
One of the ares we want to address is recovery of a
single table data.
Let say i have backups ( could be online, offline,
tablespace ) taken at 1 AM.
Users have worked and at 5AM we want to revert all the
updates done after 2 AM to one
particular table only .( Recovery is not for all
tables )
I could think of the following things :
a) If the table is the only table in the tablespace ,
then tablespace backup
and recovery / rollforward to point in time would
suffice .
Query : Can i restore and rollfoward one Tablespace to
Point in time and not do
the other tablespaces ? Will the DB be consistent ?
b) If there are multiple tables in tablespace and i
want to recover only one table
in that TS , what could be the best possible strategy
?
Ideas please ...
Thanks ,
Ravi.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
