Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.