Next Extent Sizes
Hi all, Excellent list, keep it up. How can I find out what the next extent size is for any given table? Thanks. Phil.
oncheck -pt
Phil Allen wrote:
> Hi all,
> Excellent list, keep it up.
>
> How can I find out what the next extent size is for any given table?
>
> Thanks.
>
> Phil.
In article <7k8blf$4fr$1@news.xmission.com>,
Phil Allen <phil.allen@uk.hboc.com> wrote:
>
> Hi all,
> Excellent list, keep it up.
>
> How can I find out what the next extent size is for any given table?
>
> Thanks.
>
> Phil.
>
>
So much ways... Try this query :
select nextsize from systables where tabname='tabname'. Output in pages.
--
With best regards, Yuri Dovgart,
SAP R/3, Informix consultant,
"Telecominvest" company.
E-mail y_dovgart@tci.ukrtel.net
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Phil Allen <phil.allen@uk.hboc.com> wrote in message
news:7k8blf$4fr$1@news.xmission.com...
>
> Hi all,
> Excellent list, keep it up.
>
> How can I find out what the next extent size is for any given table?
If you have 7.x or above, you can connect to the sysmaster database and run
the following SQL:
select dbsname, tabname, ti_fextsiz first_extent, ti_nextsiz next_size
from systabnames, systabinfo
where partnum = ti_partnum
and tabname = "your_table_name_here";
The systabinfo table contains lots of information about the tables in the
database. You might want to look at the table definition to see what else
might be of interest.
Thanks,
Keaton