Re: Complete in-place alters

On Oct 31, 3:29 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> 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? > > -- > Regards, > Reinhard. I have a shell script that finds the table versions on a table without using an oncheck -pT I will gladly send you a copy of it. It is based on the SQL from http://www-01.ibm.com/support/docview.wss?uid=swg21226410. I had to monkey with it a little because I had a couple of table that have no records in the new format which seemed to give this SQL issues. I will even fix any problems that you have with the script if it doesn't work for you because I would like for it to be tested on another system.