You are in trouble unless you had dropped table recovery on or are using
recovery expert.
If you dont have either one, do a re-directed restore to another database
and export the table out and
then import it back into your old database.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"SaiPrasad"
<db2udbdba-ezmlms
hield-x94588706.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/24/2004 08:20
AM Subject
facing serious problem with Prod
server










Hi
I am facing a serious problem with prod server.

In prodserver, auto commit is been set to on

I tried with a command of delete from <table name> where

Even i have not completed the where condition, but the command got
executed and all the records are deleted.
Even rollback is helpless.

How to retrieve the data,

Pl,s help


regards
saiprasad




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page