Re: Removing Outstanding In-place alter (Migrating to 9.40 from
Deepak.Patel@in.efunds.com said:
> We are in the process of migrating from IDS 9.21 UC3X1 to IDS 9.40 in Sun
> Solaris 5.7, We need to
> remove all the outstanding In-Place alters from the altered tables in the
> database.
>
> To consolidate tables into one version, I am using the following dummy
> update: UPDATE table SET
> col1=col1 WHERE 1=1;
>
> Output of oncheck -pT database:tablename before the dummy update.
>
> Home Data Page Version Summary
>
> Version Count
> (oldest) 7780
> 1 0
> 2 0
> 3 0
> 4 (current) 0
>
> Output of oncheck -pT database:tablename after the dummy update.
>
> Version Count
> (oldest) 0
> 1 0
> 2 0
> 3 0
> 4 (current) 7780
>
> Question: Does this really remove the outstanding In-Place alter or is
> there any other method
> without recreating the table in fresh ?
Well, since all the rows have moved from oldest to current, I guess it
does...?
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
sending to informix-list