Re: Re: rollback committed transactions
That's one of the strong features of IDS 10. And it have a lot of new ones. It is really worth the upgrade if one is brave enough ;) I think ER could be implemented (in 9.4) to distribute data from a primary to a secondary, that migth be of use in a situation like you had... but it migth have troubles. J. -----Original Message----- From: "Gentian Hila" <genti.tech@gmail.com> To: "Jean Sagi" <jeansagi@myrealbox.com> Date: Mon, 10 Apr 2006 12:22:09 -0400 Subject: Re: rollback committed transactions Thanks. That's too bad. We will have to engage the whole sales department to find out what is missing. At least they included it with 10. On 4/10/06, Jean Sagi <jeansagi@myrealbox.com> wrote: > No, you can't with 9.4. You need IDS 10 for that. > > You have to restore. > > > J. > > -----Original Message----- > From: "Gentian Hila" <genti.tech@gmail.com> > To: informix-list@iiug.org > Date: Mon, 10 Apr 2006 09:32:32 -0400 > Subject: rollback committed transactions > > One of hour guys deleted by mistake just a couple of records from > database (IDS9.40). We do not want to restore the back up as it would > create more problems. > > Is there a way to rrollback only records in a table ? > > Thanks a lot > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@gmail.com > Jean Sagi jeansagi@myrealbox.com jeansagi@gmail.com
Jean Sagi wrote: > That's one of the strong features of IDS 10. > And it have a lot of new ones. It is really worth the upgrade if one is brave enough ;) > > I think ER could be implemented (in 9.4) to distribute data from a primary to a secondary, that migth be of use in a situation like you had... but it migth have troubles. > > J. > > -----Original Message----- > From: "Gentian Hila" <genti.tech@gmail.com> > To: "Jean Sagi" <jeansagi@myrealbox.com> > Date: Mon, 10 Apr 2006 12:22:09 -0400 > Subject: Re: rollback committed transactions > > Thanks. > > That's too bad. We will have to engage the whole sales department to > find out what is missing. > > At least they included it with 10. > > > > > > On 4/10/06, Jean Sagi <jeansagi@myrealbox.com> wrote: >> No, you can't with 9.4. You need IDS 10 for that. >> >> You have to restore. >> >> >> J. >> >> -----Original Message----- >> From: "Gentian Hila" <genti.tech@gmail.com> >> To: informix-list@iiug.org >> Date: Mon, 10 Apr 2006 09:32:32 -0400 >> Subject: rollback committed transactions >> >> One of hour guys deleted by mistake just a couple of records from >> database (IDS9.40). We do not want to restore the back up as it would >> create more problems. >> >> Is there a way to rrollback only records in a table ? >> >> Thanks a lot >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> >> >> Jean Sagi >> jeansagi@myrealbox.com >> jeansagi@gmail.com >> > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@gmail.com Jean, Can you explain exactly what is included in Version 10 (and how to do it) to enable something like : begin; delete row; delete row; commit; (some hours later) "rollback a committed transaction that occurred a few hours ago, dealing with any subsequent activity that may have dependencies on that transaction" TBP