Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 736
  • Last Modified:

Roll Back to update command / restore from another schema

Hi,

I have run an update command without giving where clause. So my entire Table is updated by given value. Any body help me how to roll back it or restore from back up.

it is very urgent.

regards
0
itgi
Asked:
itgi
5 Solutions
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi itgi,

Do you have a good backup?


Kent
0
 
ghp7000Commented:
only thing you can do is to restore from a backup
0
 
sachinwadhwaCommented:
restore from last night's backup !

and if its a mission critical table...best of luck in your job search!
0
 
Dave FordSoftware Developer / Database AdministratorCommented:
It's pretty simple.

If you're running with any commitment control level except *NONE or *NC, you can manually issue a ROLLBACK command.

Since it's been a couple days since you posted the question, that may not be viable.

If you're running on DB2 for iSeries (a.k.a AS/400 or System i), then you could check the journaling data for the table.

Outside of those options, you'll need to restore from backup.

Good luck!
DaveSlash
0
 
srielauCommented:
The DB2 Recovery Expert can also perform logical undo. Costs $$ though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now