Contents of the OpenEdge Management Trend Database tables

Table 3–5 describes each table and identifies from which VST the information is gathered.

Table 3–5: 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.
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.

Table 3–6 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 on each filename prefix, see Table 3–1.

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


Copyright © 2006 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095