Re: Query to extract Initial & Next Extents
Hi,
This info can be found within the database (inside systables).
SELECT fextsize, nextsize
FROM systables
WHERE tabname = "your_table_name";
Your post says something about creation time. Just in case you were unaware
you can specify the creation size for extents within the CREATE TABLE
SQL.
-Bill
>
> I am currently writing queries for capacity planning and I need to be
> able to extract the initial and next extent values given to tables on
> creation. My problem is I cannot find the relevant fields in the
> sysmaster database, but I know it is there somewhere as oncheck -pt
> displays them.
>
> Cheer
>
> Dave Samuels DBA
> Siemens Microelectronics Ltd
>
>
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com