The following table describes each table and identifies from which VST the information is gathered.

Table 1. OpenEdge Management Trend Database tables
Table name Table contents Description
ActAPW Information from the _ActPWs VST Stores APW activity data, such as the number of buffer reads and writes
ActBuf Information from the _ActBuffer VST Stores buffer activity data, such as the number of marked and flushed buffers, and alternate buffer pool values (for Enterprise RDBMS only)
ActIdx Information from the _Index and _ActIndex VSTs Stores index data about overall performance
ActIOFile Information from the _ActIOFile VST Stores I/O data about each database file, except for the .lk and .lg files
ActIOType Information from the _ActIOType VST Stores database I/O data, such as the number of BI and AI blocks read
ActLock Information from the _ActLock and _LockReq VSTs Stores lock activity data, such as the number of requests and the number of database locks
ActLog Information from the _ActAILog and _ActBILog VSTs Stores activity data about before- and after-imaging
ActRec Information from the _ActRecord and _ActSummary VSTs Stores performance data about record reads, writes, and updates
ActServ Information from the _ActServer and _Server VSTs Stores server process data, such as bytes and records sent and received and the number of users
AreaStatus Information from the _AreaStatus VST Stores data about each area's HWM, Free Chain, and RM Chain
ActSum Information from the _ActSummary VST Stores database activity data, such as the number of records created and deleted
Checkpoint Information from the _Checkpoint VST Stores data about checkpoint operations
IndexStat Information from the _IndexStat and _Index VSTs Stores individual index data about reads and writes

The following table details each schema table, including fields, data types, a brief description, and how data for each field is handled when data compaction activities occur. For more information about each filename prefix, see the Table prefix definitions table.

Table 2. OpenEdge Management Trend Database table details
Filename Field name Data type Description Compaction status
Db_ActAPW ActAPW_APWQWrites Decimal Number of buffer writes from the APW queue Sum
Db_ActAPW ActAPW_BufsCkpt Decimal Number of buffers checkpointed Sum
Db_ActAPW ActAPW_BufsScanned Decimal Number of buffers scanned by the APWs Sum
Db_ActAPW ActAPW_CkptQWrites Decimal Number of buffer writes from the checkpoint queue Sum
Db_ActAPW ActAPW_Ckpts Decimal Number of checkpoints Sum
Db_ActAPW ActAPW_DBWrites Decimal Number of database writes performed by all APWs Sum
Db_ActAPW ActAPW_Flushed Decimal Number of buffers flushed at checkpoint Sum
Db_ActAPW ActAPW_Marked Decimal Number of buffers marked for writing Sum
Db_ActAPW ActAPW_ScanCycles Decimal Number of times an APW cycled through its tasks Sum
Db_ActAPW ActAPW_ScanWrites Decimal Number of scan buffer writes Sum
Db_ActAPW ActAPW_TotDBWrites Decimal Number of database writes performed by all processes Sum
Db_ActAPW ActAPW_APWEnq Decimal Number of buffers added to the APW queue Sum
Db_ActAPW ActAPW_User1 Character User-definable field Delete
Db_ActAPW Sample_ID Integer Identification number of the gathered sample Modify
Db_ActBuf ActBuf_Deferred Decimal Number of deferred buffer writes Sum
Db_ActBuf ActBuf_Flushed Decimal Database buffers flushed at checkpoint Sum
Db_ActBuf ActBuf_LogicReads Decimal Number of logical database buffer reads performed by all processes Sum
Db_ActBuf ActBuf_LogicWrites Decimal Number of logical database writes performed by all processes Sum
Db_ActBuf ActBuf_OSReads Decimal Number of physical OS database buffer reads performed by all processes Sum
Db_ActBuf ActBuf_OSWrites Decimal Number of physical OS database writes performed by all processes Sum
Db_ActBuf ActBuf_User1 Character User-definable field Delete
Db_ActBuf Sample_ID Integer Identification number of the gathered sample Modify
Db_ActIdx ActIdx_Create Decimal Number of index keys created Sum
Db_ActIdx ActIdx_Delete Decimal Number of index keys deleted Sum
Db_ActIdx ActIdx_Find Decimal Number of index keys requested Sum
Db_ActIdx ActIdx_Free Decimal Number of index blocks placed on the free chain Sum
Db_ActIdx ActIdx_Remove Decimal Number of deleted blocks removed at the end of a transaction Sum
Db_ActIdx ActIdx_Splits Decimal Number of index block splits performed Sum
Db_ActIdx ActIdx_User1 Character User-definable field Delete
Db_ActIdx Sample_ID Integer Identification number of the gathered sample Modify
Db_ActIOFile ActIOFile_BufReads Decimal Number of buffered reads from the file Sum
Db_ActIOFile ActIOFile_BufWrites Decimal Number of buffered writes to the file Sum
Db_ActIOFile ActIOFile_Extends Decimal Number of times the file was extended Sum
Db_ActIOFile ActIOFile_FileName Character Name of the file being reported on

Delete
Db_ActIOFile ActIOFile_Reads Decimal The number of times the file was read—buffered and unbuffered Sum
Db_ActIOFile ActIOFile_UnbufReads Decimal The number of times the file was read in unbuffered mode Sum
Db_ActIOFile ActIOFile_UnbufWrites Decimal The number of times the file was written in unbuffered mode Sum
Db_ActIOFile ActIOFile_User1 Character User-definable field Delete
Db_ActIOFile ActIOFile_Writes Decimal The number of writes to the file—buffered and unbuffered Sum
Db_ActIOFile Sample_ID Integer Sequential identification number of the resource Modify
Db_ActIOType ActIOType_AiReads Decimal Number of AI blocks read Sum
Db_ActIOType ActIOType_AiWrites Decimal Number of AI blocks written Sum
Db_ActIOType ActIOType_BiReads Decimal Number of BI blocks read Sum
Db_ActIOType ActIOType_BiWrites Decimal Number of BI blocks written Sum
Db_ActIOType ActIOType_DataReads Decimal Number of RM blocks read Sum
Db_ActIOType ActIOType_DataWrites Decimal Number of RM blocks written Sum
Db_ActIOType ActIOType_IdxReads Decimal Number of index blocks read Sum
Db_ActIOType ActIOType_IdxWrites Decimal Number of index blocks written Sum
Db_ActIOType ActIOType_User1 Character User-definable field Delete
Db_ActIOType Sample_ID Integer Sequential identification number of the resource Modify
Db_ActLock ActLock_CanclReq Decimal Number of lock requests canceled Sum
Db_ActLock ActLock_Downgrade Decimal Number of downgraded locks Sum
Db_ActLock ActLock_ExclFind Decimal Number of times an unused, exclusive lock was down Sum
Db_ActLock ActLock_ExclLock Decimal Number of exclusive locks granted Sum
Db_ActLock ActLock_ExclReq Decimal Number of exclusive locks requested by all processes Sum
Db_ActLock ActLock_ExclWait Decimal Number of times a process had to wait for an exclusive lock Sum
Db_ActLock ActLock_RecGetLock Decimal Number of no-lock requests granted Sum
Db_ActLock ActLock_RecGetReq Decimal Number of no-lock records requested for all processes Sum
Db_ActLock ActLock_RecGetWait Decimal Number of times a process waited for a no-lock Sum
Db_ActLock ActLock_ShrFind Decimal Number of times an unused shared lock was downgraded Sum
Db_ActLock ActLock_ShrLock Decimal Number of shared locks granted Sum
Db_ActLock ActLock_ShrReq Decimal Number of shared locks requested for all processes Sum
Db_ActLock ActLock_ShrWait Decimal Number of times a process waited for a shared lock Sum
Db_ActLock ActLock_UpgLock Decimal Number of upgrade lock requests granted Sum
Db_ActLock ActLock_UpgReq Decimal Number of lock upgrades requested for all processes Sum
Db_ActLock ActLock_UpgWait Decimal Number of times a process waited for a lock upgrade Sum
Db_ActLock ActLock_User1 Character User-definable field Delete
Db_ActLock Sample_ID Integer Identification number of the gathered sample Modify
Db_ActLog ActLog_AIBBufWaits Decimal Number of AI busy buffer waits experienced Sum
Db_ActLog ActLog_AIByteWrites Decimal Number of AI bytes written to the after-image file Sum
Db_ActLog ActLog_AINoBufAvail Decimal Number of times there were no AI buffers available Sum
Db_ActLog ActLog_AIPartialWrites Decimal Number of partial AI buffer writes performed Sum
Db_ActLog ActLog_AIRecWrites Decimal Number of notes written to the AI file Sum
Db_ActLog ActLog_AITotWrites Decimal Number of AI writes performed by all processes Sum
Db_ActLog ActLog_AIWWrites Decimal Number of AI writes performed by the AIW Sum
Db_ActLog ActLog_BIBBufWaits Decimal Number of BI busy buffer waits experienced Sum
Db_ActLog ActLog_BIByteReads Decimal Number of BI bytes read by all processes Sum
Db_ActLog ActLog_BIByteWrites Decimal Number of BI bytes written to the BI file Sum
Db_ActLog ActLog_BIEBufWaits Decimal Number of BI empty buffer waits experienced Sum
Db_ActLog ActLog_BIPartialWrites Decimal Number of partial BI buffer writes performed Sum
Db_ActLog ActLog_BIRecReads Decimal Number of BI notes read by all processes Sum
Db_ActLog ActLog_BIRecWrites Decimal Number of all BI notes written to the BI file Sum
Db_ActLog ActLog_BITotReads Decimal Number of BI block reads performed by all processes Sum
Db_ActLog ActLog_BITotWrites Decimal Number of BI writes performed by all processes Sum
Db_ActLog ActLog_BIWWrites Decimal Number of BI writes performed by the BIW Sum
Db_ActLog ActLog_User1 Character User-definable field Delete
Db_ActLog Sample_ID Integer Identification number of the gathered sample Modify
Db_ActRec ActRec_ByteCreate Decimal Size, in bytes, created by all processes Sum
Db_ActRec ActRec_ByteDel Decimal Number of bytes deleted by all processes Sum
Db_ActRec ActRec_ByteRead Decimal Number of bytes read by all processes Sum
Db_ActRec ActRec_ByteUpd Decimal Number of bytes updated by all processes Sum
Db_ActRec ActRec_FragCreate Decimal Number of record fragment creates performed by all processes Sum
Db_ActRec ActRec_FragDel Decimal Number of record fragment deletes performed by all processes Sum
Db_ActRec ActRec_FragRead Decimal Number of record fragment reads performed by all processes Sum
Db_ActRec ActRec_FragUpd Decimal Number of record fragment updates performed by all processes Sum
Db_ActRec ActRec_RecCreate Decimal Number of record creates performed by all processes Sum
Db_ActRec ActRec_RecDel Decimal Number of record deletes performed by all processes Sum
Db_ActRec ActRec_RecLock Decimal Number of record locks created for all processes Sum
Db_ActRec ActRec_RecRead Decimal Number of record reads performed by all processes Sum
Db_ActRec ActRec_RecUpd Decimal Number of record updates performed by all processes Sum
Db_ActRec ActRec_RecWait Decimal Number of record waits for all processes Sum
Db_ActRec ActRec_User1 Character User-definable field Delete
Db_ActRec Sample_ID Integer Identification number of the gathered sample Modify
Db_ActServ ActServ_ByteRec Decimal Number of bytes received from the client for this server Sum
Db_ActServ ActServ_ByteSent Decimal Number of bytes sent to the client for the server Sum
Db_ActServ ActServ_CurrUsers Decimal Number of current logins to the server Average
Db_ActServ ActServ_Logins Int64 Highest number of simultaneous logins for the server Average
Db_ActServ ActServ_MaxUsers Decimal Maximum number of logins to the server Average
Db_ActServ ActServ_MsgRec Decimal Number of promsgs received from the client Sum
Db_ActServ ActServ_MsgSent Decimal Number of promsgs sent to the client for the server Sum
Db_ActServ ActServ_Num Decimal Server number for the database Save
Db_ActServ ActServ_PID Integer Process identification number of the server Delete
Db_ActServ ActServ_PortNum Integer Port number on which the server operates Delete
Db_ActServ ActServ_QryRec Decimal Number of queries received from the client for the server Sum
Db_ActServ ActServ_RecRec Decimal Number of records received from the client for the server Sum
Db_ActServ ActServ_RecSent Decimal Number of records sent to the client for the server Sum
Db_ActServ ActServ_TimeSlice Decimal Number of times the limit number of records for a request has been interrupted to service another Sum
Db_ActServ ActServ_Type Character The type of server (SQL, ABL, etc.) Save
Db_ActServ ActServ_User1 Character User-definable field Delete
Db_ActServ Sample_ID Integer Identification number of the gathered sample Modify
Db_ActSum ActSum_AllocNewRm Decimal Number of times space was allocated on the RM Sum
Db_ActSum ActSum_BytesAlloc Decimal Number of bytes allocated for records Sum
Db_ActSum ActSum_Examined Decimal Number of examined data blocks on the RM chain Sum
Db_ActSum ActSum_FromFree Decimal Number of times space was allocated from the free chain Sum
Db_ActSum ActSum_FromRm Decimal Number of times space was allocated from the RM chain Sum
Db_ActSum ActSum_Removed Decimal Number of blocks removed from the RM chain Sum
Db_ActSum ActSum_RetFree Decimal Number of times a free block was returned to the free chain Sum
Db_ActSum ActSum_TakeFree Decimal Number of times a free block was taken from the free chain Sum
Db_ActSum ActSum_AiWrites Decimal Number of AI block writes performed by all processes Sum
Db_ActSum ActSum_BiReads Decimal Number of BI block reads performed by all processes Sum
Db_ActSum ActSum_BiWrites Decimal Number of BI block writes performed by all processes Sum
Db_ActSum ActSum_Commits Decimal Number of commits performed by all processes Sum
Db_ActSum ActSum_DbAccesses Decimal Number of database block requests by all processes Sum
Db_ActSum ActSum_DbExtend Decimal Number of times the database was extended Sum
Db_ActSum ActSum_DbReads Decimal Number of database block reads performed by all processes Sum
Db_ActSum ActSum_DbWrites Decimal Number of database block writes performed by all processes Sum
Db_ActSum ActSum_Undos Decimal Number of transaction undos or backouts performed Sum
Db_ActSum ActSum_User1 Character User-definable field Delete
Db_ActSum Sample_ID Integer Identification number of the gathered sample Modify
Db_AreaStatus Sample_ID Integer Identification number of the gathered sample Modify
Db_AreaStatus AreaStatus_Areaname Character Name of the area Save
Db_AreaStatus AreaStatus_Areanum Decimal Number of the area Save
Db_AreaStatus AreaStatus_TotBlocks Decimal Total number of blocks in the area Average
Db_AreaStatus AreaStatus_Hiwater Decimal Largest number of blocks to which the database has grown Average
Db_AreaStatus AreaStatus_Extents Decimal Number of extents in the area Save
Db_AreaStatus AreaStatus_FreeNum Int64 Number of free blocks Average
Db_AreaStatus AreaStatus_Rmnum Int64 Number of Record Manager (RM) blocks on the RM chain Average
Db_AreaStatus AreaStatus_User1 Character User-definable field Delete
Db_Checkpoint Checkpoint_ApwQ Decimal Number of buffers placed in the APW write queue Average
Db_Checkpoint Checkpoint_CkptQ Decimal Number of buffers placed in the checkpoint queue Average
Db_Checkpoint Checkpoint_Date Date The date the checkpoint started Delete
Db_Checkpoint Checkpoint_Dirty Decimal Number of dirty buffers at the beginning of the checkpoint Average
Db_Checkpoint Checkpoint_Flush Decimal Number of buffers flushed at the end of the checkpoint Average
Db_Checkpoint Checkpoint_Length Character Length, in seconds, of the checkpoint Average
Db_Checkpoint Checkpoint_Num Decimal Checkpoint number Average
Db_Checkpoint Checkpoint_Scan Decimal Number of buffers scanned by all of the APWs Average
Db_Checkpoint Checkpoint_Time Character Begin time for the checkpoint Average
Db_Checkpoint Checkpoint_User1 Character User-definable field Delete
Db_Checkpoint Sample_ID Integer Identification number of the sample Modify
Db_IndexStat IndexStat_Blockdelete Decimal Number of blocks deleted from the index by all processes Sum
Db_IndexStat IndexStat_Create Decimal Number of keys created in the index by all processes Sum
Db_IndexStat IndexStat_Delete Decimal Index ID in the database Sum
Db_IndexStat IndexStat_IndexName Character The name of the index for this information Save
Db_IndexStat IndexStat_IdxNum Int64 Index number within the database Save
Db_IndexStat IndexStat_Read Decimal Number of keys read in the index by all processes Sum
Db_IndexStat IndexStat_Split Decimal Number of blocks split in the index by all processes Sum
Db_IndexStat IndexStat_User1 Character User-definable field Delete
Db_IndexStat Sample_ID Integer Identification number of the gathered sample Modify
Db_IndexStat IndexStat_TableName Character The name of the table for this information Save
Db_TableStat Sample_ID Integer Identification number of the gathered sample Modify
Db_TableStat TableStat_Create Decimal Number of records created in the table by all processes Sum
Db_TableStat TableStat_Delete Decimal Number of records deleted from the table by all processes Sum
Db_TableStat TableStat_Read Decimal Number of records read in the table by all processes Sum
Db_TableStat TableStat_Table_ID Decimal Table number within the database Save
Db_TableStat TableStat_TableName Character The name of the table for this information Save
Db_TableStat TableStat_Update Decimal Number of records updated in the table by all processes Sum
Db_TableStat TableStat_User1 Character User-definable field Delete