Accidentally i have deleted some data . Now when i wanted to recover the table space with option torba but the last image copy on the tablespace requested by the job is not available. (tape got scratched for some reason).
Is there a way i can recover the tablespace.
Is there a way to undo what i have today(i mean delete).
Any help is appreciated. ....
hurry please,

Do you have an older backup that's ok + all the logs since? You could restore from that, although it may take a while to roll forward through them.

No, thats the only image copy on this table. But i have all the log tapes
will that be okay...can u be more specific

Can you find the scratched tape and try to recatalog it (assuming the tape has not been reused)?

If not, I don't know of anyway to recover without an image copy.

You really don't have a lot of options here without a backup. If you have an old backup and logs you can restore from that and RF to just before your delete, otherwise you may be out of luck. There's no way to roll back committed transactions.

if it is OS/390 , you any 3rd party tool , like BMC change manager or Platinum( now CA tools log analyser ) , if yes , you restore it by using above tools


Hope it may help


Thank You

Lekharaju Ennam

we are not having any tools for the matter of fact. But, definetly this is a good time to look for one. guys, do you know where can i get some info about tools availble. we are os/390 r2v10 and db2 v7.1.
Regarding the data, application shall take care of it...
thanks a lot to u all for the responding.

If I remember correctly, BMC has a facility using which you can give the "FROM" and "TO" time(No RBA etc needed) and it will generate UNDO DDL/DML/DCL etc . Then you can run that to undo. It uses the LOG to generate the SQL. It is mostly valid for very recent changes like what you did accidental delete.

But since you don't have BMC, I don't know any other way.