Try OpenEdge Now
skip to main content
Debugging and Troubleshooting
Troubleshooting Resources : Other Diagnostics Resources : Run-time diagnostics : Supported virtual system tables for temp-tables
 
Supported virtual system tables for temp-tables
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.