hi,

I have one issue that, i deleted 15rows from the table test. After 10min of deletion, i need those 15rows back. So how can we get those. Explain in brief please.



thanks & regards
vijay

Restore and roll forward

Chances of getting that increases provided you have archival mode of logging and not circular.....

or if you have recovery expert : this can recover deletes from the log

no its not possible. i need those rows only. How
for eg: i didnt take backup of that db. So how can we get those rows?

we can restore tablespace or database by using restore command. But here the point is, i need rows only. So how it will possible? HOw can we get those deleted rows.

If you say "delete from table" and commit this there is no "legal" chance to restore the rows deleted with SQL. There is no "trash"-area in relational databases except you create one yourself and handle it yourself. But as a dba you can *try* to restore them.

At least you need a backup copy of the database containing the rows.

Which DB2 do you use?
DB2 zOS V8++:
Use the UNLOAD Utility to unload all the rows of the table from that copy (needs the FROMCOPY-clause) Delete all rows not needed from the unloadfile and load the ones you want into the original table.

DB2 UDB:
Restore the database backup into another database usindg RESTORE REDIRECT. Use the EXPORT comand to export the rows you need and the IMPORT command to load them into the original database.

I coult post samples for both platforms.

Regards,
Volker.

Maybe I'm missing your point, but what's the problem? You take the backup, restore it in another system/DB2 instance that you set up, extract the rows you want and export them, then load them again in the desired target system.