The OpenEdge database engine provides virtual system tables (VSTs), which allow applications to get status and activity information on a given database. ABL provides access to these VSTs. Temp-tables are stored in an OpenEdge database. Therefore, VSTs can support temp-tables. This support allows an application to gather information on a given temp-table, and obtain the number of records that are created, modified, and deleted. It can also examine the status of a database and monitor its performance.
The supported virtual system tables for monitoring deployed clients are listed below:
_ActBuffer
_ActIndex
_ActIOFile
_ActIOType
_ActOther
_ActRecord
_ActSpace
_ActSummary
_Block
_BuffStatus
_DbStatus
_Filelist
_IndexStat
_MstrBlk
_StatBase
_TableStat
_Trans
_UserIndexStat
_UserIO
_UserTableStat
Note: The _TableStat and _UserTableStat tables contain exactly the same records, since there is only one user accessing the temp-tables. The same applies to the _IndexStat and _UserIndexStat temp-tables.
For more information on each of these VSTs, see OpenEdge Data Management: Database Administration.
_ActBuffer