> #### Contents of the FathomTrendDatabase tables

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

> Table 3–5: FathomTrendDatabase 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 this field is handled when data compaction activities occur.

> For more information on each filename prefix, see Table 3–1.

> Table 3–6: FathomTrendDatabase 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 | Decimal | 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, 4GL, 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 | Decimal | Number of free blocks. | Average
> Db_AreaStatus | AreaStatus_RMNum | Decimal | 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_ID | Integer | Sequential identification number of the process. | Average
> Db_Checkpoint | Checkpoint_Length | Character | Length, in seconds, of the checkpoint. | Average
> Db_Checkpoint | Checkpoint_Num | Integer | Checkpoint number. | Average
> Db_Checkpoint | Checkpoint_Scan | Integer | 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_ID | Integer | Sequential identification number of the record. | Modify
> Db_IndexStat | IndexStat_Indexname | Character | The name of the index for this information. | Save
> Db_IndexStat | IndexStat_IdxNum | Integer | 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_TableID | Integer | 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 © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095