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.
|