RE: Complete in-place alters

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 tolocks): 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? -- Regards, Reinhard.