Recently I clean up one table and loaded recent prod data.Unforuntly i didn't take back up previous table records. Is possible to recover those table records?
It depends on, how you did the clean up, how many rows were deleted and how recent?
a) ran DELETE statement
b) Truncate
c) Dummy load
If its test, best option is to copy the data from some other environment and work on it. If you have built the data, depending on the method used to cleanup, data can be got back from the logs if possible, it also depends on the log retention policy of your shop and how important the data is.
Best person would be your DBA to make that call, because unknown to you if there are image copies taken in the weekend. You will be lucky
It depends on, how you did the clean up, how many rows were deleted and how recent?
a) ran DELETE statement
b) Truncate
c) Dummy load
If its test, best option is to copy the data from some other environment and work on it. If you have built the data, depending on the method used to cleanup, data can be got back from the logs if possible, it also depends on the log retention policy of your shop and how important the data is.
Best person would be your DBA to make that call, because unknown to you if there are image copies taken in the weekend. You will be lucky
Thanks,
Sushanth
Hi sushan,
Thanks For yor replay..I used DELETE STATEMENT..
Is possible to use RESTORE QUERY?
RESTORE DATABASE dbname TABLESPACE (tablespace_name,tablespace_name,...) FROM directory TAKEN AT timestamp
;
But, I didn't know what value we need to give in "'directory'"
That's DB2 LUW not mainframe DB2 z/OS, it will not work.
Since, you have used DELETE statement, going through the logs is your option. So to do that, you should have tools like Log Analyzer at your shop. Since it takes lots of CPU and recalls lots of log datasets, best advice to you is contact your DBA.
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
cmsmoon wrote:
Recently I clean up one table and loaded recent prod data.Unforuntly i didn't take back up previous table records. Is possible to recover those table records?
The way you write it, it looks like, you've loaded the data to 'test-region'. Unless, you've your own back of the "earlier user data", chances of getting it back are very slim. Logs might be of help, as Sushanth has pointed to, but for a single user request I dobut if DBA team will be that friendly.