RE: Informix 9.40: Need Script to Determine Which Tables Have IN-
Hi, Clifton,
This is a fragment from '9.40 migration guide':
(the original script contained 3 errors, I've corrected
them, sorry for the copyright violation)
............
To find outstanding in-place alters, execute the following SQL statements:
-- set OPTCOMPIND to 0;
database sysmaster;
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 pp with no log;
select b.dbsname database, b.tabname table
from systabnames b, pp where partn = partnum
..............
The only problem with that script is that it shows ALL
tables under 'in-place alter table', including those,
that do not have OLD-FORMAT pages any more
(for example, fake update was made against these tables)
It's interesting to find a way to filter out processed tables
------------------------------------------
Alexey Sonkin
-----Original Message-----
From: Clifton M. Bean [mailto:cmbean@sbcglobal.net]
Does anyone have a script that will run against a sysmaster table that will
quickly identify which tables within a database have active in-place alter
tables.
I used to have one that worked on 7.3+ instances but the sysmaster tables
used by that script no longer exist in 9.40.
I added sapmix to the email list believing that, perhaps, an SAP OSS note
may address this issue and can be used by the non-SAP world to locate these
tables.
Thanks in advance.
Clifton