|
View previous topic :: View next topic
|
| Author |
Message |
roopannamdhari
Warnings : 1
New User
Joined: 14 Sep 2006
Posts: 71
Location: Bangalore
|
|
|
|
Hi,
Is there any mechanism in DB2 to take back up of DB2 table data.i mean....how to get db2 table data after refreshing table.
Thanks.. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| how to get db2 table data after refreshing table |
Ah, the same ways as before the data is refreshed. . .?
I am sure that there is something i am missing 
Maybe if you explain the question/issue in more detail, someone will be able to provide a more useful reply. |
|
| Back to top |
|
|
roopannamdhari
Warnings : 1
New User
Joined: 14 Sep 2006
Posts: 71
Location: Bangalore
|
|
|
|
DB2 table is already refreshed,now i want to get back the data which i lost after refreshing the table.so is there any to get back that data
Incase if insert trigger is set on that table,what ever records we INSERT, UPDATE or DELETE will be inserted to another table(could say backup table)
But if table is not having any such trigger then is there any other approach to get that data. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| is there any other approach to get that data |
You can only "get back" what you have. . . If there was no backup made, probably not.
If you have a much older backup and can reprocess every update in the same sequence as it was processed originally originally, you could conceivably get back (roll forward) to the point where the data is what you want.
Suggest you ask your dba what might be available on your system. This will be quite site-specific. |
|
| Back to top |
|
|
|
|
