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
