Re: Complete in-place alters

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...

Fernando Nunes 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"? Because finding out that you have outstanding in-place alters when you need to revert and it's 3 AM on a Monday morning and your boss is screaming at you is a very unpleasant place to be. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com