Table 3–6: 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
|
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 cancelled.
|
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_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
|