Re: in place alter messing things up

Ok, thanks for the replies. I'm surprised I haven't seen this more often. So it's relatively normal behavior. Thanks, floyd ----- Original Message ----- Subject: Re: in place alter messing things up Date: Fri, November 9, 2007 13:59 From: "bozon" <curtis@crowson1.com> On Nov 9, 12:45 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > > Our developers are getting ready for a big upgrade tomorrow. Their script modifies > tables, which is causing in place alters. No biggy right ? > > But, then they are running an internal edit application which edits rows through a > cursor. They are having issues where certain rows are trying to be updated twice, > as if the cursor got messed up. > > > > The workaround for us on this, is to update all the rows in the table so that > there aren't any rows using the other version of the table. > > > > Is this a bug ? I haven't heard or seen this behavior before. > > Is there another simpler workaround I should be looking at ? ( update stats on the > table doesn't fix it ). I thought of making a checkpoint , but their application > has no authority to run an onmode -c > > > > Any thoughts or advice ? > > > > Thanks, > > floyd > > I have run into problems with in place alters, but only on upgrades. > We have a nibble script that gets rid of ipa rows slowly so as not to > interfere with our users. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

On Nov 9, 2:42 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Ok, thanks for the replies. > I'm surprised I haven't seen this more often. So it's relatively normal > behavior. > > Thanks, > floyd > > ----- Original Message ----- > Subject: Re: in place alter messing things up > Date: Fri, November 9, 2007 13:59 > From: "bozon" <cur...@crowson1.com> > > On Nov 9, 12:45 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > > > Our developers are getting ready for a big upgrade tomorrow. Their > script modifies > > tables, which is causing in place alters. No biggy right ? > > > But, then they are running an internal edit application which edits > rows through a > > cursor. They are having issues where certain rows are trying to be > updated twice, > > as if the cursor got messed up. > > > > The workaround for us on this, is to update all the rows in the table > so that > > there aren't any rows using the other version of the table. > > > > Is this a bug ? I haven't heard or seen this behavior before. > > > Is there another simpler workaround I should be looking at ? ( update > stats on the > > table doesn't fix it ). I thought of making a checkpoint , but their > application > > has no authority to run an onmode -c > > > > Any thoughts or advice ? > > > > Thanks, > > > floyd > > > I have run into problems with in place alters, but only on upgrades. > > We have a nibble script that gets rid of ipa rows slowly so as not to > > interfere with our users. > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list I think it is a bug. I just know when upgrading the database to 10 we had issues when we still had in place alters.