I want to recover deleted rows from my db2 database. I have save the log file before delete row. Is there any way to recover back deleted row from log file. My log file is like this S0000001.log
-
-
No this is not possible unless you have purchased db2 recovery expert. You can use a trail version though and check this type of recovery your self.
There are other recovery options available to accomplish above task rather than mining log which is tedious and error prone.
1) Restore old db backup and extract data(PIT recovery)
2)you the option of restoring only set of tablespaces that contain table along with catalog tablespace.
Cheers, Vijay
Comment