Roll Back to update command / restore from another schema


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.

Who is Participating?
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
Hi itgi,

Do you have a good backup?

ghp7000Connect With a Mentor Commented:
only thing you can do is to restore from a backup
sachinwadhwaConnect With a Mentor Commented:
restore from last night's backup !

and if its a mission critical of luck in your job search!
Dave FordConnect With a Mentor Software 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!
srielauConnect With a Mentor Commented:
The DB2 Recovery Expert can also perform logical undo. Costs $$ though.
All Courses

From novice to tech pro — start learning today.