> #### Report output field and column headings

> This section identifies the fields or column headings associated with each historical report template.

> Note: Fields and column headings in this section that are identified with an asterisk (*) are also the Fathom-supplied defaults associated with each report type.

> ##### AppServer Application Profile

> Table 2–2 identifies the AppServer Application Profile column headings.

> Table 2–2: AppServer Application Profile column headings
> Run Count* | Average Request Duration (ms) | Maximum Request Duration (ms)
> Return Code Success | Return Code Error | Return Code Quit
> Return Code Stop | Sample Count | –

> ##### AppServer Performance

> Table 2–3, Table 2–4, and Table 2–5 identify the column headings for an AppServer Performance graphical report.

> Table 2–3: AppServer Client Activity column headings
> Average Active Clients* | Maximum Active Clients | Client Requests
> Average Client Requests | Maximum Client Requests | Sample Count

> Table 2–4: AppServer Broker Activity column headings
> Requests Completed | Requests Queued | Requests Queued %
> *Average Request Duration (ms) | Maximum Request Duration (ms) | Average CPU Usage %
> Maximum CPU Usage % | Average Memory Usage (k) | Maximum Memory Usage (k)
> Sample Count | – | –

> Table 2–5: AppServer Activity column headings
> Average Pool CPU Usage % | Maximum Pool CPU Usage % | Average Pool Memory Usage % (k)
> Maximum Pool Memory Usage (k) | *Average Busy Server Count | Maximum Busy Server Count
> Average Busy Server Time (ms) | Average Locked Server Count | Maximum Locked Server Count
> Average Locked Server Time (ms) | Sample Count | –

> ##### Database After-Imaging

> Table 2–6 identifies the column headings for a Database After-Imaging graphical report.

> Table 2–6: Database After-Imaging column headings
> ActLog_AIBBufWaits | ActLog_AIByteWrites | ActLog_AINoBufAvail
> ActLog_AIPartialWrites | ActLog_AIRecWrites | ActLog_AITotWrites*
> ActLog_AIWWrites* | – | –

> ##### Database Area Status

> Table 2–7 identifies the column headings for a Database Area Status graphical report.

> Table 2–7: Database Area Status column headings
> Sample Count | Total Blocks | Hi Water Mark*
> Free Blocks | RM Blocks | Blocks Available*
> Pct. Blocks Available | – | –

> ##### Database Before-Imaging

> Table 2–8 identifies the fields for a Database Before-Imaging graphical report.

> Table 2–8: Database Before-Imaging fields
> ActLog_BITotReads | ActLog_BITotWrites* | ActLog_BIWWrites*
> ActSum_BIReads | ActSum_BIWrites | ActLog_BIBBufWaits
> ActLog_BIByteReads | ActLog_BIByteWrites | ActLog_BIEBufWaits
> ActLog_BIPartialWrites | ActLog_BIRecReads | ActLog_BIRecWrites

> ##### Database Checkpointing

> Table 2–9 identifies the column headings for a Database Checkpointing graphical report.

> Table 2–9: Database Checkpointing column headings
> Sample Count | Checkpoint Length* | Buffer Scanned
> Checkpoint Queue | APW Queue | Buffers Flushed*

> ##### Database Details

> Table 2–10 identifies the fields for a Database Details graphical report.

> Table 2–10: Database Details fields
> ActBuf_Flushed | ActBuf_LogicReads* | ActBuf_LogicWrites*
> ActSum_DbReads | ActSum_DbWrites | ActRec_RecRead
> ActLog_BITotWrites | ActLog_BIWWrites | ActAPW_APWEnq
> ActIOType_IdxReads | ActIOType_IdxWrites | ActAPW_APWQWrites
> ActAPW_BufsCkpt | ActAPW_BufsScanned | ActAPW_CkptQWrites
> ActAPW_Ckpts | ActAPW_DBWrites | ActAPW_Marked
> ActAPW_ScanCycles | ActAPW_ScanWrites | ActAPW_TotDBWrites
> ActBuf_Deferred | ActBuf_OSReads | ActBuf_OSWrites
> ActIdx_Create | ActIdx_Delete | ActIdx_Find
> ActIdx_Free | ActIdx_Remove | ActIdx_Splits
> ActLock_CancelReq | ActLock_Downgrade | ActLock_ExclFind
> ActLock_ExclLock | ActLock_ExclReq | ActLock_ExclWait
> ActLock_RecGetLock | ActLock_RecGetReq | ActLock_RecGetWait
> ActLock_ShrFind | ActLock_ShrLock | ActLock_ShrReq
> ActLock_ShrWait | ActLock_UpgLock | ActLock_UpgReq
> ActLock_UpgWait | ActRec_ByteCreate | ActRec_ByteDel
> ActRec_ByteRead | ActRec_ByteUpd | ActRec_FragCreate
> ActRec_FragDel | ActRec_FragRead | ActRec_FragUpd
> ActRec_RecCreate | ActRec_RecDel | ActRec_RecLock
> ActRec_RecUpd | ActRec_RecWait | ActSum_AllocNewRm
> ActSum_BytesAlloc | ActSum_Examined | ActSum_FromFree
> ActSum_FromRm | ActSum_Removed | ActSum_RetFree
> ActSum_TakeFree | ActSum_AiWrites | ActSum_BiReads
> ActSum_Commits | ActSum_DBAccesses | ActSum_DbExtend
> ActSum_Undos | ActLog_AIBBufWaits | ActLog_AIByteWrites
> ActLog_AINoBufAvail | ActLog_AiPartialWrites | ActLog_AIRecWrites
> ActLog_AITotWrites | ActLog_AIWWrites | ActLog_BIBufWaits
> ActLog_BIByteReads | ActLog_BIByteWrites | ActLog_BIEBufWaits
> ActLog_BIPartialWrites | ActLog_BIRecReads | ActLog_BIRecWrites
> ActLog_BITotReads | ActIOType_AiReads | ActIOType_AiWrites
> ActIOType_BiReads | ActIOType_BiWrites | ActIOType_DataReads
> ActIOType_DataWrites | – | –

> ##### Database Disk Information

> Table 2–11 identifies the fields for a Database Disk Information graphical report.

> Table 2–11: Database Disk Information fields
> ActSum_DbReads | ActSum_DbWrites | ActAPW_DBWrites*
> ActAPW_TotDBWrites* | ActSum_DbAccesses | ActSum_DbExtend
> ActIOType_AiReads | ActIOType_AiWrites | ActIOType_BiReads
> ActIOType_BiWrites | ActIOType_DataReads | ActIOType_DataWrites
> ActIOType_IdxReads | ActIOType_IdxWrites | –

> ##### Database Index Analysis

> Table 2–12 identifies the column headings for a Database Index Analysis graphical report.

> Table 2–12: Database Index Analysis column headings
> Sample Count | Max Block Count | Min Block Count
> Avg Block Count | Max Byte Count | Min Byte Count
> Avg Byte Count | Max Util Percent | Min Util Percent
> Avg Util Percent* | Max Level Count | Min Level Count
> Avg Level Count | – | –

> ##### Database Index Usage

> Table 2–13 identifies the column headings for a Database Index Usage graphical report.

> Table 2–13: Database Index Utilization column headings
> Index Reads* | Index Splits | Index Creates
> Index Deletes | – | –

> ##### Database Locking

> Table 2–14 identifies the fields for a Database Locking graphical report.

> Table 2–14: Database Locking fields
> ActLock_CancelReq | ActLock_Downgrade | ActLock_ExclFind
> ActLock_ExclLock | ActLock_ExclReq | ActLock_ExclWait*
> ActLock_RecGetLock | ActLock_RecGetReq | ActLock_RecGetWait*
> ActLock_ShrFind | ActLock_ShrLock | ActLock_ShrReq
> ActLock_ShrWait* | ActLock_UpgLock | ActLock_UpgReq
> ActLock_UpgWait* | – | –

> ##### Database Buffer I/O

> Table 2–15 identifies the fields for a Database Buffer I/O graphical report.

> Table 2–15: Database Memory Usage fields
> ActBuf_Flushed | ActBuf_LogicReads* | ActBuf_LogicWrites
> ActBuf_Deferred | ActBuf_OSReads* | ActLog_AIBBufWaits
> ActLog_AINoBufAvail | ActLog_AIPartialWrites | ActLog_BIBBufWaits
> ActLog_BIEBPartialWaits | ActLog_BIPartialWrites | –

> ##### Database Record Information

> Table 2–16 identifies the fields for a Database Record Information graphical report.

> Table 2–16: Database Record Information fields
> ActRec_RecRead | ActRec_RecCreate* | ActRec_RecDel*
> ActRec_ByteRead | ActRec_ByteUpd | ActRec_FragCreate
> ActRec_FragDel | ActRec_FragRead | ActRec_FragUpd
> ActRec_RecCreate | ActRec_RecDel | ActRec_RecLock*
> ActRec_RecUpd* | ActRec_RecWait | ActRec_ByteCreate
> ActRec_ByteDel | – | –

> ##### Database Server Activity

> Table 2–17 identifies the column headings for a Database Server Activity graphical report.

> Table 2–17: Database Server Activity column headings
> Messages Received | Messages Sent | Bytes Received
> Bytes Sent | Records Received* | Records Sent*
> Min Users | Max Users | Avg Users

> ##### Database Summary

> Table 2–18 identifies the fields for a Database Summary graphical report.

> Table 2–18: Database Summary fields
> ActBuf_Flushed | ActBuf_LogicReads* | ActBuf_LogicWrites*
> ActSum_DbReads | ActSum_DbWrites | ActRec_RecRead
> ActLog_BITotWrites | ActLog_BIWWrites | ActAPW_BufsCkpt
> ActBuf_OSReads | ActBuf_OSWrites | ActIdx_Create
> ActIdx_Delete | ActIdx_Find | ActIdx_Free
> AdxIdx_Remove | ActIdx_Splits | ActSum_Commits
> ActSum_DbAccesses* | ActSum_DbExtend | ActIOType_DataReads
> ActIOType_IdxReads | ActIOType_IdxWrites | –

> ##### Database Table Analysis

> Table 2–19 identifies the column headings for a Database Table Analysis graphical report.

> Table 2–19: Database Table Analysis column headings
> Sample Count | Max Record Count | Min Record Count
> Ave Record Count* | Max # of Bytes | Min # of Bytes
> Ave # of Bytes | Max # of Fragments | Min # of Fragments
> Ave # of Fragments | Max Scatter Factor | Min Scatter Factor
> Ave Scatter Factor | – | –

> ##### Database Table Usage

> Table 2–20 identifies the column headings for a Database Table Usage graphical report.

> Table 2–20: Database Table Usage column headings
> Record Reads* | Record Updates* | Record Creates*
> Record Deletes* | – | –

> ##### CPU Summary

> Table 2–21 identifies the fields for a CPU Summary graphical report.

> Table 2–21: CPU Summary fields
> CPU_User* | CPU_System* | CPU_Wait*
> CPU_Idle | – | –

> ##### File Summary

> Table 2–22 identifies the column headings for a File Summary graphical report.

> Table 2–22: File Summary column headings
> Sample Count | Average File Size (k)* | Minimum Size (k)
> Maximum Size (k) | – | –

> ##### Network Activity

> Table 2–23 identifies the column headings for a Network Activity graphical report.

> Table 2–23: Network Activity column headings
> Sample Count | Avg. Response* | –

> ##### System Disk Device Activity

> Table 2–24 identifies the column headings for a System Disk Device Activity graphical report.

> Table 2–24: System Disk Device Activity column headings
> Sample Count | Pct Busy* | Avg Queue
> Avg Wait | Avg Serve | Minimum Busy
> Maximum Busy | – | –

> ##### System Filesystem Usage

> Table 2–25 identifies the column headings for a System Filesystem Usage graphical report.

> Table 2–25: System Filesystem Usage column headings
> Sample Count | Capacity | Pct Used*
> Current Available | Maximum Available | Minimum Available

> ##### System Memory Summary

> Table 2–26 identifies the column headings for a System Memory Summary graphical report.

> Table 2–26: System Memory Summary column headings
> Max System Memory | Min System Memory | Max Virtual Memory
> Min Virtual Memory | Max Free System Memory | Min Free System Memory
> Max Free Virtual Memory | Min Free Virtual Memory | Pages In
> Pages Out | – | –

> ##### WebSpeed Application Profile

> Table 2–27 identifies the column headings for a WebSpeed Application Profile graphical report.

> Table 2–27: WebSpeed Application Profile column headings
> Run Count* | Average Request Duration (ms) | Maximum Request Duration (ms)
> Sample Count | – | –

> ##### WebSpeed Performance

> Table 2–28, Table 2–29, and Table 2–30 identify the column headings for a WebSpeed Performance graphical report.

> Table 2–28: WebSpeed Client Activity column headings
> Average Active Clients* | Maximum Active Clients | Client Requests
> Average Client Requests | Maximum Client Requests | Sample Count

> Table 2–29: WebSpeed Broker Activity column headings
> Requests Completed | Requests Queued | Requests Queued %
> *Average Request Duration (ms) | Maximum Request Duration (ms) | Average CPU Usage %
> Maximum CPU Usage % | Average Memory Usage (k) | Maximum Memory Usage (k)
> Sample Count | – | –

> Table 2–30: WebSpeed Server Activity column headings
> Average Pool CPU Usage % | Maximum Pool CPU Usage % | Average Pool Memory Usage (k)
> Maximum Pool Memory Usage (k) | *Average Busy Server Count | Maximum Busy Server Count
> Average Busy Server Time (ms) | Average Locked Server Count | Maximum Locked Server Count
> Average Locked Server Time(ms) | Sample Count | –

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