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 Manage the OpenEdge Database.