Могу предложить еще два варианта (чистый SQL, поэтому подходит под любую платформу), один на базе какого старого IBM FAQ, а второй взят из ukr.comp.dbms.informix. Но , насколько я помню, оба были довольно длительными по времени выполнения (правда, все относительно :))

-----------------------------------------------------------
-- 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;
===============================
-----------------------------------------------------------
-- Find the tables with active in-place alters (2-nd variant)
-- (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 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
========================