how do i undelete a truncated table?

#1

I've used Oracle's flashback but we don't have HA in our DB2 9.7.1 UDB
- linux system. We have backups. But restoring this huge database into
another system is going to take tons of hours, even with tablespace
backup.
Is there a log miner or something like flashback in DB2 so we could
use this going forward?

#2

On 8/4/2010 4:02 AM, Arun Srini wrote:

Quote:

I've used Oracle's flashback but we don't have HA in our DB2 9.7.1 UDB
- linux system. We have backups. But restoring this huge database into
another system is going to take tons of hours, even with tablespace
backup.
Is there a log miner or something like flashback in DB2 so we could
use this going forward?
There is a tool called recover expert. I'm not familiar with it, but I

think it does log mining and such.

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

#3

You can use (buy !) High Performance Unload for DB2.
This tool unloads tables to files "dirty", it bypasses the DB2 engine
so you can unload table date of a table which is "unaccessible".
For your situation: HPU can also unload tables out of a backup file!
This seems to meet your requirements.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how do i undelete a truncated table?

comp.databases.ibm-db2 comp.databases.ibm-db2

how do i undelete a truncated table? - 08-03-2010 , 03:02 PM

Re: how do i undelete a truncated table? - 08-03-2010 , 06:40 PM

Re: how do i undelete a truncated table? - 08-06-2010 , 04:03 AM