SEO

#1 (**permalink**) 02-26-2008, 06:18 PM

hello,

What is the simplest way, with no lost of data hopefully to recover
from a dropped table. I am using hot backup.

Also, what constitute database files in the backup statement and is
there a list of how to recover for each type of file corruption eg
data file or config file? The doc doesn't seem to list the case
scenario of how to recover from each case.

Thanks

DB2 Convert

#2 (**permalink**) 02-26-2008, 06:19 PM

The tablespace needs to have DROPPED TABLE RECOVERY=ON (this is the
default option on CREATE TABLESPACE).

To learn more, search on DROPPED TABLE RECOVERY here:

http://publib.boulder.ibm.com/infoce...help/index.jsp

DB2 Convert wrote:
> hello,
>
> What is the simplest way, with no lost of data hopefully to recover
> from a dropped table. I am using hot backup.
>
> Also, what constitute database files in the backup statement and is
> there a list of how to recover for each type of file corruption eg
> data file or config file? The doc doesn't seem to list the case
> scenario of how to recover from each case.
>
> Thanks
>
> DB2 Convert

#3 (**permalink**) 02-26-2008, 06:24 PM

blair,

Thanks. But it seems to me there is lost of data implied for the tablespace
level rollforward recovery. Beside the dropped table that causes possible data
lost, what else can cost the data lost in an irrecoverable manner. Reason being
if I can guard against those, I can do pretty well in avoiding losing data.

Thanks

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

SEO

database file and drop a table