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