RE: Complete in-place alters

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"? 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. In Migration Guide chapter 1: Overview of Dynamic Server Migration page 1.3 and 1.4 topics: Upgrading Dynamic Server (In-place Migration) and Migrating Dynamic Server (Non-in-place Migration): 1. Prepare your system. That includes removing outstanding in-place alters, ... May be the reason is the reverting issue as you an OTC pointed out. Anyway it seems to be no mistake to the job. What I'm looking for is some advice to do it well... Any further suggestions? -- Regards, Reinhard.