AutoCollect – Creating SNAPSHOT and System DELTA Rowsets › Process Snapshot Rowsets into Delta Rowsets › Delta Row Format

Delta Row Format

The information loaded into the Delta row is very similar to the corresponding DST table row with additional columns added to the front of the row to uniquely identify the Delta rowset.

• D_MUF_ENABLE—Date and time this execution of MUF was enabled
• D_MUF_START_DATETIME—Start date and time from the starting Snapshot
• D_MUF_END_DATETIME—End date and time of the ending Snapshot
• D_MUF_TYPE—Type of DELTA, either INTERVAL or LAST
• D_MUF_TOTALROW—Type of row, either Y for a total row or N for a normal row
• D_MUF_DURATION—Duration in hours that this Delta represents

By combining the first four fields with the MUF_NAME column found on each table, each Delta rowset can be uniquely identified.