RE: identifying in place alters
Try oncheck -pT <db>. Tables with more than one version listed have in-place alters pending according to Informix support a few years ago. It does makes a very large report...
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of Keith Simmons
Sent: Wednesday, September 13, 2006 3:00 PM
To: Floyd Wellershaus
Cc: informix-list@iiug.org
Subject: 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
>
>
>
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list