Unanswered: Reading logs - looking for one DELETE OR UPDATE statement?
few minutes ago I understood that in the last month I have done one or few deletes and updates on my production database that was wrong. Problem is that I know only that I have done it in last three weeks as a user "db2inst1". Now I have to find them. I have parameter logretain ON, I have all logs that I need, just don't have any idea how to find that.
And the one positive thing is that I'm looking only for changes made on a few tables.
I've heard that there is tool to read logs... but unfortunetly don't know anything about this. I would like something like
select "delete" from ... where user ="db2inst1" and table="tab1"
Is there any possibility for this or something similar?
DB2 v8, AIX
Thank you in advance... and help is appreciated
Is it data critical.Can you manage to shutdown the database.
If so ,then:
1.Take an OFFLINE backup of current database.
2.Use this to create a new database.
3.Restore the database to a point in time where u haven't done the modifications using a prior backup and log files.
4.Compare the tables in both the databases to see the changed data.
5.Make the changes in the new database u have created.
6.Take an Offline backup of the new database.
7.Use this Offline backup to restore the Oraiginal database.
I think this should work.Try this strategy on a test enviorment first.It worked for me fine.