Compaction details for system tables

Table 3–12 summarizes how the compaction process affects data rows contained in the specified tables.

Table 3–12: System tables and the compaction process
System table
What happens to table data during compaction
Sys_CPU
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
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.


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