Get current usage of extents

[D.Cook]

Is there a way to work out how much a data extent file is being used?
For example I want to know what percentage is used in database.d1 so I can add a new fixed extent before it fills up and the variable overflow extent gets used.

I'm sure I figured this out once, maybe using data from the TABANALYS report, but was hoping somebody might have a ready answer for what seems to be a fairly necessary query.

Using OE 10.1C if it makes any difference..

 

[RealHeavyDude]

You might have a look into the _AeraStatus and _AreaExten VSTs. The contain the information you need and you can directly query them from within the ABL.

HTH, RealHeavyDude.

 

[Cecil Snodgrass]

The prostrct utility
prostrct statistics db-name

 

[D.Cook]

Thanks guys