RE: Next Extent Sizes
This information is stored in the systables system catalog table for each
database.
Example:
database <database name>;
select tabname, nextsize from systables; -- All tables including systemcatalog tables
or
database <database name>;
select tabname, nextsize from systables where tabid > 99; -- All UserDefined Tables
or
database <database name>;
select tabname, nextsize from systables where tabname = "<table name>"; --Retrieve specific table name
or
You can execute dbschema with the -ss option to get extent size information
for tables.
Randy W. McDaniel
Senior Database Administrator
Fidelity Investments
100 Crosby Parkway
Covington, KY 41015
e-mail: Randy.McDaniel@fmr.com
work: (606) 386-5554
> -----Original Message-----
> From: Phil Allen [SMTP:phil.allen@uk.hboc.com]
> Sent: Wednesday, June 16, 1999 9:47 AM
> To: informix-list@iiug.org
> Subject: 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.