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

Thanks, I will check your utility. I had already noticed that dbschema did not show me the real extent size, it was different from the size in systables. Regards ----- Original Message ----- From: "Art S. Kagel" <kagel@bloomberg.net> To: "Francisco Roldan" <f_roldan@admcentralagricola.com.gt> Sent: Wednesday, July 07, 2004 12:36 PM Subject: Re: Getting Table's Extent Size and Next Extent Size IDS 7.30 > [This is an email copy of a Usenet post to "comp.databases.informix"] > > 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 > sending to informix-list