|
View previous topic :: View next topic
|
| Author |
Message |
cmsmoon
New User
Joined: 17 Jun 2010
Posts: 75
Location: Chennai
|
|
|
|
Hi Friends,
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? |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Hi cmsmoon,
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 |
|
| Back to top |
|
|
cmsmoon
New User
Joined: 17 Jun 2010
Posts: 75
Location: Chennai
|
|
|
|
| sushanth bobby wrote: |
Hi cmsmoon,
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'"
for your reference
it.toolbox.com/blogs/db2luw/db2-recovery-basics-part-1-22758 |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
cmsmoon,
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.
Thanks,
Sushanth |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
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. |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
