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
