current next extent size
Hi, how to query the sysmaster-db to get the current next_extent_size for all tables. I have to compare this values with the original ones. Is there a way with a sql-statement? Thanks for advices. Matthias Informix Version 7.24
Hi
first thanks for the answers.
The SQL that I searched for was:
{### no returns for fragmented tables ###}
database sysmaster;
select
tabname
,nextsiz * 2 next_kb
from org_db:systables a, sysptnhdr b
where a.partnum = b.partnum
and a.tabid > 99
Matthias
(Please excuse my short problem-description)
"M. K'ching" <koeching@landwirtschaftsverlag.com> schrieb im Newsbeitrag
news:917i29$261l$1@mars.ms.tlk.com...
> Hi,
>
> how to query the sysmaster-db to get the current next_extent_size for all
> tables. I have to compare this values with the original ones.
> Is there a way with a sql-statement?
>
> Thanks for advices.
>
> Matthias
>
> Informix Version 7.24
>
>
In article <91cs7g$1j5q$1@mars.ms.tlk.com>,
"M. K'ching" <koeching@landwirtschaftsverlag.com> wrote:
> Hi
>
> first thanks for the answers.
> The SQL that I searched for was:
>
> {### no returns for fragmented tables ###}
>
Yes you can:
database sysmaster;
select dbsname, tabname, ti_nextsiz
from systabnames t, systabinfo i
where partnum = ti_partnum
and tabname not matches "_*"
order by 1,2
NB this will show indexes too, under the tabname heading; you can
filter these out with a join to systables & sysindexes in the database
you're interested in.
You can also do a link to <your db>.systables & sysfragments to only
show fragmented tables.
What it DOESN'T show (it can be done but it's tricky) is what fragment
the nextsize refers to ....:-} good ol' Informix
Sent via Deja.com
http://www.deja.com/