Time line:
1_ Made backup of database
2_ Deleted a row from table that deleted +100 others records in other tables since they where with the constrait ON DELETE CASCADE.
3_ Made backup of database
4_ Made a lot valid of updates/deletes/inserts.
5_ Need to recover the data lost in 2
I've seen the rollforward db2 command, but it's no use, since I didn't have the log active before the changes in 4 were made.
Is there a something along the lines of a diff of backups to made the recovery and insert of data pleasant?
Or is there any other way to recover the data that was lost easily? I mean, i could do it by hand following every ON DELETE CASCADE, but i wanna work smart, not hard!