_AreaExtent Questions

Hi All,

Firstly let me try to explain what I am doing and then ask the question.

I am trying to make an automated background job that will loop through every hour or so and check the size of database extents.

I have noticed that I am running this, stop it, add a few records to one of the tables and re-run this, it does not seem to pick up the Database size change. I actually have to stop my AppBuilder session and restart for it to pick these changes up. Does anyone know why this would be the case and how I can get around it please?

Thanx in advance for any assistance offered.
Cya.

/*****************************************************
PS. I lied about the size changing when I restart the session sorry, it does not seem to change at all. The only thing that I could see that changed where the _AreaStatus._AreaStatus-totblocks and _AreaStatus._AreaStatus-hiwater. Does anyone have any ideas on how to monitor the size of the DB extents programatically?

******************************************************/
 
Hi All,

Just to let you all know, instead of using the _AreaExtent table I now use the _FileList. Something like:

FOR EACH _FileList NO-LOCK
WHERE _FileList._FileList-Name = vExtentPath:

IF _FileList._FileList-Size > vExtentSize THEN
DO:
opMsg = "Warning: Database (" + vExtentPath + ") has grown to "
+ TRIM(STRING(_FileList._FileList-Size,">>>,>>>,>>9")) + " kb. "
+ "Please add a new Extent.".
END.

END.

This does the job just fine.

Cya.
 
Top