Removing Outstanding In-place alter (Migrating to 9.40 from 9.21)
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
0 (oldest) 7780
1 0
2 0
3 0
4 (current) 0
Output of oncheck -pT database:tablename after the dummy update.
Version Count
0 (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 ?
TIA
Deepak
*****************************************************************************************
This electronic mail message is intended solely for the named recipients and may contain
confidential and proprietary business information of eFunds Corporation and all its subsidiaries.If
you are not a named recipient, please notify the sender immediately.You may not disclose the
contents to any other person; use this electronic mail message or its contents for any other
purpose; or further store or copy its contents in any medium.
*****************************************************************************************
sending to informix-list
On Wed, 08 Sep 2004 09:13:01 -0400, Deepak.Patel wrote: That's the way it's done. By updating every row in the table you have forced the engine to perform the schema change to every row rewriting each in the newest format. Art S. Kagel > 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; ><SNIP> > Question: Does this really remove the outstanding In-Place alter or is there > any other method without recreating the table in fresh ? > > TIA > > Deepak