Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Roll back mass updation happened on table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
picus_mf
Warnings : 1

New User


Joined: 09 Jun 2006
Posts: 51

PostPosted: Fri Jul 04, 2008 3:32 pm    Post subject: Roll back mass updation happened on table
Reply with quote

Hi,
One of the tables in our database has been effected with wrong updation. Our intention was to update some 5 records at once, but 24000 records out of 1 million records are updated due to lack of specific condition.

Is there any way other approaching DBA where we can roll back the update and bring back the records to its previous status?

Thanks in Advance.
Praveen.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Fri Jul 04, 2008 3:43 pm    Post subject: Reply to: Roll back mass updation happened on table
Reply with quote

Quote:
Is there any way other approaching DBA where we can roll back the update and bring back the records to its previous status?


once a program has properly terminated, the changes have been committed and no roll backs are possible

You just incurred in a programming/analysis error and as such must be fixed by other means than standared Data Base utilities

... if there is an image copy available of the table before the_wrong_program_execution
You might ask support to reload it and operations to rerun all the jobs affecting the table in question
but You need to carefully coordinate everything
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jul 05, 2008 12:03 am    Post subject:
Reply with quote

Hello,

Problems with databases should be brought to the attention of the database support people - immediately.

The longer the delay the more invalid "answers" the system can provide.

It is one thing to make a mistake. It is a far worse thing to try to hide it.
Back to top
View user's profile Send private message
picus_mf
Warnings : 1

New User


Joined: 09 Jun 2006
Posts: 51

PostPosted: Mon Jul 07, 2008 2:09 pm    Post subject:
Reply with quote

Thanks for the replies.

The updation happened was on test data base. We wanted to know if there is any process that can be done to roll back the updations.
Any way...next course of action is taken.

Thanks once again.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 07, 2008 7:56 pm    Post subject:
Reply with quote

Hello,

Quote:
We wanted to know if there is any process that can be done to roll back the updations.
There should be, but they will be controlled by the dba(s).
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Mon Jul 07, 2008 8:38 pm    Post subject:
Reply with quote

You can do a recover to a point in time if there have been no updates since your mass updates but if there are foreign keys you will have to check these and if your mass update caused any cascading changes you would have to fix those also. It is best to ask the DBA for help.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Mass comment and edit elixir1986 IBM Tools 3 Thu Mar 02, 2017 10:09 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us