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 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 and time of the last operation on this area. The datetime displays in the following format: Thu Dec 23 16:24:20 2021.

In general, when datetime information is unavailable, the field displays as "?". For After Image extents, when the broker is offline, the last operation for AI extents is unavailable and _AreaStatus-LastOp displays as "?". However, when the broker is online, _AreaStatus-LastOp fields continue to display "?" until the AI extent is modified.
_AreaStatus-LastOp-TZ TIMESTAMP The date and time of the last operation on this area. The datetime displays in datetime-tz format, for example, 12/23/2021 16:24:20.881-05:00.

In general, when datetime information is unavailable, the field displays as "?". For After Image extents, when the broker is offline, the last operation for AI extents is unavailable and _AreaStatus-LastOp-TZ displays as "?". However, when the broker is online, _AreaStatus-LastOp-TZ fields continue to display "?" until the AI extent is modified.
_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