The following table summarizes how the compaction process affects data rows contained in the database tables.

Table 1. Configuration tables and the compaction process
Database table What happens to table data during compaction
Db_ActAPW This is a multi-row table in which most rows are summed during the compaction process.
Db_ActBuf This is a multi-row table in which most rows are summed during the compaction process.
Db_ActIdx This is a multi-row table in which most rows are summed during the compaction process.
Db_ActIOFile This is a multi-row table. The key to this table is Sample_ID and FileName.
Db_ActLock This is a multi-row table in which most rows are summed during the compaction process.
Db_ActRec This is a multi-row table in which most rows are summed during the compaction process.
Db_ActSum This is a multi-row table in which most rows are summed during the compaction process.
Db_Checkpoint Data is deleted and not compacted.
Db_TableStat This is a multi-row table. The key to this table is Sample_ID and TableID.
Db_IndexStat This is a multi-row table. The key to this table is Sample_ID and IndexNum.
Db_ActServ The compaction process reflects a mixing of sums and averages. This is a multi-row table. The key to this table is Sample_ID and Server Number. Every time you start and stop the database, the servers change.
DB_ActLog This is a multi-row table in which most rows are summed during the compaction process.
DB_ActIOType This is a multi-row table in which most rows are summed during the compaction process.
Db_AreaStatus This is a multi-row table. The key to this table is Sample_ID and Area Name.