Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Area status (_AreaStatus)
 
Area status (_AreaStatus)
The _AreaStatus VST displays a variety of data about the status of areas.
Field name
Data Type
Description
_AreaStatus-AIActivated
CHARACTER
The the date/time that AI was activated
_AreaStatus-AI-Seq
INTEGER
The sequence number of each AI file
_AreaStatus-State
CHARACTER
The state of each AI file in the database. Valid values are:
*EMPTY
*FULL
*BUSY
*LOCKED
_AreaStatus-Areaname
CHARACTER
Area name
_AreaStatus-Areanum
INTEGER
Area number
_AreaStatus-Extents
INTEGER
Number of extents in an area
_AreaStatus-Freenum
INT64
Number of blocks on the free chain
_AreaStatus-Hiwater
INT64
Highest block used
_AreaStatus-Lastextent
CHARACTER
Name of extent where high-water mark resides
_AreaStatus-LastOp
CHARACTER
The date/time of the last operation on this area
_AreaStatus-Rmnum
INT64
Number of blocks on the rm chain
_AreaStatus-Totblocks
INT64
Total number of blocks in an area
_AreaStatus-Type
CHARACTER
The type of area. Valid values include:
*AI
*BI
*TL
*Data
*Control