Re: dummy update 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 |