Previous Topic: AutoCollect DELTA DatabaseNext Topic: Delta Identification Columns

AutoCollect DELTA Database › Delta Rowsets

Delta Rowsets

For each Delta rowset created, one or more rows are added to the Delta tables. Delta tables that have multiple rows per rowset will have one or more total rows also created.

SQL Name

Table

Detail Rows

Total Rows

D_BUSINESS_VALUE_DETAILS

BVD

1

0

D_BUSINESS_VALUE_METRICS

BVM

1

0

D_MUF_ACCOUNTING

MFY

1 per acct table*

1

D_MUF_AREA_STATS

MFA

1 per area*

1

D_MUF_COVEREDVIRTUAL

MFC

1 per definition*

2

D_MUF_CBS

MCB

1

0

D_MUF_CONFIG

MFC

1 peer configuration parameter*

0

D_MUF_INTERNAL_STATS

MFV

1

0

D_MUF_OPTIONS

MFO

1

0

D_MUF_RETURN_CODES

MFU

1 per DB return code*

1

D_MUF_SMP_STATS

MFW

1

0

D_MUF_SRB_ZIIP

MFC

1 per SRB*

1

D_MUF_SYSTEM_STATS

MFS

1

1

D_MUF_TABLE_STATS

MFT

1 per table*

1

D_MUF_TCB_OR_SRB

MTC

1 per subtask*

1

D_SQL_MISC_STATS

SQM

1

0

D_SQL_SQLCODES

SQQ

1 per SQL code*

1

Note: Asterisk (*) indicates that the number of rows is dependent on the active number of DST participants at the time the Snapshot (used to build the Deltas) was taken.

Using the example above where the customer created 8 Snapshot rowsets in a given week, the Delta rows would be as follows: