Re: identifying in place alters
Floyd
Don't know about oncheck, but the following should find them:-
#!/bin/ksh
tblpartnum=1048577
numdbs=`dbaccess sysmaster <<EOF 2> /dev/null |grep -v max|awk '{print $0}'
select {+ full(sysdbstab)} max(dbsnum) from sysdbstab
EOF`
i=1
while (( i <= $numdbs ))
do
dbaccess sysmaster <<EOF
select hex(t1.pg_partnum)
, t1.pg_pagenum
, t1.pg_physaddr
, hex(t2.partnum)
, t3.tabname
from syspaghdr t1
, sysptntab t2
, systabnames t3
where t1.pg_partnum=$tblpartnum
and t1.pg_flags=2
and t1.pg_next !=0
and t1.pg_physaddr=t2.physaddr
and t2.partnum=t3.partnum
EOF
let i=i+1
let tblpartnum=tblpartnum+1048576
done
Keith
On 13/09/06, Floyd Wellershaus <fwellers@yahoo.com> wrote:
>
>
> What is the best way to identify which tables ( or rows within tables if
> possible ) have in place alters ?
> Carlton Doe said today in a Informix Chat that there was an oncheck that can
> identify the tables, but I don't see it.
>
> Thanks,
>
> floyd
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
>