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 © 2008 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095