> ### System tables

> If you configure Fathom to monitor system resources, Fathom stores the gathered data in the Trend Database System tables. Table 3–10 lists each System table's contents.

> Table 3–10: System tables
> Table name | Table contents | Description
> --- | --- | ---
> CPU | CPU data | Contains CPU data for Fathom instances that are trended to the FathomTrendDatabase.
> Memory | Memory data | Contains Memory data for the Fathom instances that are trended to the FathomTrendDatabase.
> Dev | Disk Device data | Contains Disk Device data for the Fathom instances that are trended to the FathomTrendDatabase. The disk device is typically a local drive, but can also be an NFS-type drive.
> FileSys | File System data | Contains File System data for the Fathom instances that are trended to the FathomTrendDatabase.
> FileSize | File Size data | Contains File Size data for monitored files.
> Process | Process data | Contains data about OpenEdge server processes.

> Table 3–11 lists the field names, data types, a brief description, and how data for this field is handled when data compaction activities occur for each System table. For more information on the filename prefix, see Table 3–1.

> Table 3–11: System table details
> Filename | Field name | Data type | Description | Compaction status
> --- | --- | --- | --- | ---
> Sys_CPU | CPU_System | Decimal | Percentage of system activity on the CPU. | Average
> Sys_CPU | CPU_Idle | Integer | Percentage of time that the CPU is idle. | Average
> Sys_CPU | CPU_User1 | Character | User-definable field. | Delete
> Sys_CPU | CPU_Usr | Decimal | Percentage of user activity on the CPU. | Average
> Sys_CPU | CPU_Wait | Decimal | Percentage of wait I/O on the CPU. | Average
> Sys_CPU | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> Sys_Dev | Dev_AvgQue | Decimal | Average of queue activity on the disk. | Sum
> Sys_Dev | Dev_AvgServ | Decimal | Average of service time on the disk. | Sum
> Sys_Dev | Dev_AvgWait | Decimal | Average wait time on the disk. | Sum
> Sys_Dev | Dev_Name | Character | Name of the device. | Save
> Sys_Dev | Dev_Pct_Busy | Decimal | Percentage of time the device was busy. | Average
> Sys_Dev | Dev_User1 | Character | User-identifiable field. | Delete
> Sys_Dev | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> Sys_Mem | Mem_PgIn | Integer | Number of memory pages paged in. | Sum
> Sys_Mem | Mem_PgOut | Integer | Number of memory pages paged out. | Sum
> Sys_Mem | Mem_SysFree | Decimal | Physical memory in system blocks free on the system. | Average
> Sys_Mem | Mem_SysTot | Decimal | Physical memory in system blocks available on the machine. | Average
> Sys_Mem | Mem_User1 | Character | User-definable field. | Delete
> Sys_Mem | Mem_VirtFree | Decimal | Virtual memory in system blocks free on the system. | Sum
> Sys_Mem | Mem_VirtTot | Decimal | Virtual memory in system blocks available on the machine. | Sum
> Sys_Mem | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> Sys_FileSys | FileSys_Avail | Decimal | Number of available blocks on the file system. | Average
> Sys_FileSys | FileSys_Capacity | Integer | Number of total blocks on the file system. | Average
> Sys_FileSys | FileSys_Mount | Character | Name of directory where the file system is mounted. | Save
> Sys_FileSys | FileSys_Name | Character | Name of the file system. | Save
> Sys_FileSys | FileSys_UsedPct | Decimal | Percentage of the file system used. | Average
> Sys_FileSys | FileSys_User1 | Character | User-definable field. | Delete
> Sys_FileSys | Sample_ID | Integer | Identification number of the gathered sample. | Modify
> Sys_Process | Process_PID | Decimal | Process ID of the process being monitored. | Save
> Sys_Process | Process_PPID | Decimal | Parent process ID of the process being monitored. | Save
> Sys_Process | Process_CPUUser | Decimal | Amount of CPU time (in seconds) dedicated to user. | Sum
> Sys_Process | Process_CPUSystem | Decimal | Amount of CPU time (in seconds) dedicated to system. | Sum
> Sys_Process | Process_ElapsedTime | Decimal | Elapsed process time (in seconds) since last poll. | Average
> Sys_Process | Process_CPUPct | Decimal | Percentage of CPU usage since last poll. | Average
> Sys_Process | Process_CPUPctWT | Decimal | Percentage of CPU usage since last poll (weighted per CPU). | Average
> Sys_Process | Process_UserName | Character | Name of the user attached to the process. | Save
> Sys_Process | Process_UserGroup | Character | Name of the group related to the process. | Save
> Sys_Process | Process_Command | Character | The command executed. Note: This field contains only the executable. | Save
> Sys_Process | Process_CommandArgs | Character | Arguments fed to the command. | Save
> Sys_Process | Process_VirtMem | Decimal | Virtual memory size (as defined by the operating system). | Sum
> Sys_Process | Process_ResMemory | Decimal | Resident memory size (as defined by the operating system). | Sum
> Sys_Process | Process_StartTimeStamp | Character | Date and time that the process started. | Save
> Sys_Process | Sample_ID | Integer | Identification number of the gathered sample. | Modify

> The schema of system tables is dependent upon many subsystems. Figure 3–5 diagrams the relationship among the different system tables.

> Figure 3–5: System table relationships

> Figure 3–5 describes the data gathered about trended system information. Every SYS_ table contains the sample's ID number. The sample table stores data from the gathered sample that applies to all the tables. The sample table also contains the sample's Site and Resource IDs. A control record in the control table generates the Sample ID.

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