Getting Table's Extent Size and Next Extent Size IDS 7.30
Francisco Roldan asked how to get the initial and next extent sizes of an existing table on IDS 7.30. Nebojsa Sevo and Malc P said to use dbschema with the -ss option; Nebojsa and scottishpoet also gave a query on systables (fextsize, nextsize). Art S. Kagel noted dbschema shows only create-time values adjusted for extent doubling, and recommended his myschema utility from the utils2_ak package.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi everybody,
how can I get the initial extent size and next extent size
of an already created table. I am sure that I calculated
it, but I can not get the values now.
I tried with dbschema but it does not give me table's extent size
information.
Informix Dynamic Server Version 7.30.UC11
Thanks in advance.
Regards
sending to informix-list
If you are using dbschema you must use "-ss" (server specific) option:
dbschema -d db_name {-t tab_name} -ss
You can also use:
select tabname, fextsize, nextsize from systables
Nebojsa
On Tue, 6 Jul 2004 17:26:11 -0600, "Francisco Roldan"
<f_roldan@admcentralagricola.com.gt> wrote:
>
>Hi everybody,
>how can I get the initial extent size and next extent size
>of an already created table. I am sure that I calculated
>it, but I can not get the values now.
>
>I tried with dbschema but it does not give me table's extent size
> information.
>
>Informix Dynamic Server Version 7.30.UC11
>
>Thanks in advance.
>
>Regards
>
>
>
>sending to informix-list
------------------------------------
Remove spam block (DELETE_) to reply
"Francisco Roldan" <f_roldan@admcentralagricola.com.gt> wrote in message news:<ccfd6v$30t$1@news.xmission.com>...
> Hi everybody,
> how can I get the initial extent size and next extent size
> of an already created table. I am sure that I calculated
> it, but I can not get the values now.
>
> I tried with dbschema but it does not give me table's extent size
> information.
>
dbschema -ss -d <database> -t <table> etc
> Informix Dynamic Server Version 7.30.UC11
>
> Thanks in advance.
>
> Regards
>
>
>
> sending to informix-list
select tabname, fextsize, nextsize from systables where tabid >= 100;
"Francisco Roldan" <f_roldan@admcentralagricola.com.gt> wrote in message news:<ccfd6v$30t$1@news.xmission.com>...
> Hi everybody,
> how can I get the initial extent size and next extent size
> of an already created table. I am sure that I calculated
> it, but I can not get the values now.
>
> I tried with dbschema but it does not give me table's extent size
> information.
>
> Informix Dynamic Server Version 7.30.UC11
>
> Thanks in advance.
>
> Regards
>
>
>
> sending to informix-list
On Tue, 06 Jul 2004 19:26:11 -0400, Francisco Roldan wrote:
You need to pass the -ss option to dbschema. However, dbschema will only
report the create-time values of EXTENT SIZE and of NEXT SIZE adjusted for
extent doubling as the table grew.
You can also try my dbschema replacement utility, myschema, which will
optionally calculate optimal extent sizing and allow for predicted growth (see
descriptions of the -a, -m, -M, -e & -n options in the Usage). Myschema is
included in the package utils2_ak downloadabel from the IIUG Software
Repository.
Art S. Kagel
> Hi everybody,
> how can I get the initial extent size and next extent size of an already
> created table. I am sure that I calculated it, but I can not get the values
> now.
>
> I tried with dbschema but it does not give me table's extent size
> information.
>
> Informix Dynamic Server Version 7.30.UC11
>
> Thanks in advance.
>
> Regards
>
>
>
> sending to informix-list