Re: dummy update

i am migrating to v10 but the guide for 9.4 says this under "remove outstanding in-place alters" the db server cannot convert if there are any outstanding in-place alters remove outstanding in-place alters before converting by running a 'dummy' update statement against each table pointed that direction by infx support - does not seem quite right but that is what it says and the thread is correct, it will not work to do so against SERIAL type so thanks much for the replies! T

tomcaml@yahoo.com wrote: > i am migrating to v10 > but the guide for 9.4 says this under "remove outstanding in-place > alters" > > the db server cannot convert if there are any outstanding > in-place alters > remove outstanding in-place alters before converting by > running a 'dummy' update statement against each table > > pointed that direction by infx support - does not seem quite right but > that is what it says > > and the thread is correct, it will not work to do so against SERIAL > type so thanks much for the replies! Look for the Perl script to diagnose tables with outstanding IPAs in the IIUG archives. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

What about this mini SQL ? ----------------------------------------------------------- -- Find the tables with active in-place alters -- (detect tables modified by an in-place alter statement) -- These include tables whose data pages are completely converted to the new form. -- oncheck -pT <database>:<table> -- -- Set OPTCOMPIND to 0 in the configuration file or environment and run -- -- V.Shulzhenko DBA Tools (by IBM FAQ) 08'2002 ----------------------------------------------------------- set isolation to dirty read;select pg_partnum + pg_pagenum - 1 partn from syspaghdr, sysdbspaces a where pg_partnum = 1048576 * a.dbsnum + 1 and pg_next != 0 into temp _temp_dbatools with no log; ----------------------------------------------------------- select b.dbsname[1,18] database ,b.tabname[1,18] table from systabnames b, _temp_dbatools where partn = partnum order by 1,2; and another ----------------------------------------------------------- -- Find the tables with active in-place alters (2-nd variant) -- (by UCDI) ----------------------------------------------------------- set isolation to dirty read;select t3.dbsname[1,18] database ,t3.tabname[1,18] table ,hex(t2.partnum) partnum_hex from syspaghdr t1, sysptntab t2, systabnames t3 where t1.pg_flags=2 and t1.pg_next !=0 and t1.pg_physaddr=t2.physaddr and t2.partnum=t3.partnum --order by 1,2