Just curious: Why do you need to that ?


J.


tomcaml@yahoo.com escribis:
> hello!
>
> anyone have a script or trick to spit put dummy updates needed for all
> tables in all DB's?
>
> as in, update carriertbl set add_user = add_user where 1=1;
>
>
> thanks!
>
> tom
sending to informix-list

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