Next Extent Sizes
Phil Allen asked how to find the next extent size for a given table. Madison Pruet suggested oncheck -pt. Yuri Dovgart suggested selecting nextsize from systables for the table name, with output in pages. Keaton Adams said that on 7.x or later one can query sysmaster, joining systabnames and systabinfo on partnum = ti_partnum and selecting ti_fextsiz and ti_nextsiz. Answered with several options.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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