Re: Complete in-place alters

Habichtsberg, Reinhard wrote: > Obnoxio The Clown wrote: >> 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. > > To avoid screaming of my boss because every day production is disturbed by > oncheck -pT (either it don't run to an end or it blocks production due to> locks): Is there any other way to find out which tables have pending > in-place alters than oncheck -pT? Any sysmaster-table or database system > table that could be asked and built into a little per-database > fake-update-program? I don't know if it's changed in 11, but in prior versions it was less invasive to just dummy update the entire database (once you'd locked the schema, of course!) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com