finding inplace alters
Hi,
Running ids10.0.fc5 on aix5.3 and needing to upgrade to 10.0.fc11 to get a bugfix.
trying to find and fix inplace alters. The script ibm supplies doesn't work for mulitple reasons so far. It fails on some oncheck -pp's and also when it builds a list of tables out of our 60k plus tables, it runs out of memory.
So I am trying to use this that i got from somewhere a while ago, but I guess it's not reliable because even after I do the dummy updates the tables still show up.
Any idea of a decent way to at least find the inplace atlers on a huge ass database with over 60,000 tables some of them containing billions of rows ?
Thanks,
floyd
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;
unload to altered_tabsselect b.dbsname database, b.tabname table from systabnames b, pp where partn = partnum;
On Nov 17, 4:35 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote:
> Hi,
> Running ids10.0.fc5 on aix5.3 and needing to upgrade to 10.0.fc11 to get a bugfix.
> trying to find and fix inplace alters. The script ibm supplies doesn't work for mulitple reasons so far. It fails on some oncheck -pp's and also when it builds a list of tables out of our 60k plus tables, it runs out of memory.
>
> So I am trying to use this that i got from somewhere a while ago, but I guess it's not reliable because even after I do the dummy updates the tables still show up.
>
> Any idea of a decent way to at least find the inplace atlers on a huge ass database with over 60,000 tables some of them containing billions of rows ?
>
> Thanks,
> floyd
>
> 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;
>
> unload to altered_tabs> select b.dbsname database, b.tabname table from systabnames b, pp where partn = partnum;
Yes - there is a problem in the IBM script where it is getting the
version and count. I fixed it. Will send the script in email. See if
that works.
--Chavan