Getting Table's Extent Size and Next Extent Size IDS 7.30

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