Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
OpenEdge Management Trend Database Schema : OpenEdge Management Trend Database tables : Compaction details for database tables
 

Compaction details for database tables

The following table summarizes how the compaction process affects data rows contained in the database tables.
Table 8. 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.