> #### Compaction details for database tables

> Table 3–7 summarizes how the compaction process affects data rows contained in the database tables.

> Table 3–7: 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.

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