Re: Complete in-place alters

On Oct 30, 6:18 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > Habichtsberg, Reinhard wrote: > > Hi all, > > > In preperation for migration from IDS 9.40 to 11.5 we have to complete all > > in-place alters. We have tables up to a billion rows with many pending > > in-place alters. The amount of data adds up to some TB. > > Why do you "have to"? Is that in IDS 11.50 documentation? > I know that this question can turn this into an hot topic... I browsed through > the documentation very quickly and I think that step is not there... > > Note that if you need to revert you should not have pending in-place alter tables. > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... It is in my 11.5 migration guide. I have an elaborate trickle fake update shell script if anyone is interested. Of course I think it cheats and uses a version 10 feature so it wouldn't be appropriate for Reinhard. It used to not cheat but I found it faster and easier to cheat.