Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
OpenEdge Management Trend Database Schema : System tables : Compaction details for system tables
 

Compaction details for system tables

The following table summarizes how the compaction process affects data rows contained in the specified tables.
Table 13. System tables and the compaction process
System table
What happens to table data during compaction
Sys_CPU
The averages will be stored.
Sys_Dev
This is a multi-row table. The key to this table is Sample_ID and Device Name.
Sys_Mem
The content reflects a mixing of compaction and averages.
Sys_FileSize
This is a multi-row table in which averages are stored. The key to this table is Sample_ID and Name 2 additional fields—Max and Min.
Sys_FileSys
This is a multi-row table in which averages are stored. The key to this table is Sample_ID and Mount.
Sys_Process
This is a multi-row table. The key to this table is Sample_ID and Process PID.