Previous Topic: First Snapshot Rowset for a Given MUF Execution (MUFNAME and S_MUF_ENABLE)Next Topic: Last Snapshot for a given MUF execution

AutoCollect – Creating SNAPSHOT and System DELTA Rowsets › Process Snapshot Rowsets into Delta Rowsets › Delta Processing Rules › Next Snapshot for a Given MUF Execution

Next Snapshot for a Given MUF Execution

Create a Delta row with fixed values from the corresponding Snapshot row.

Row

Value

D_MUF_ENABLE

from S_MUF_ENABLE (ending Snapshot)

D_MUF_START_DATETIME

from S_MUF_DATETIME (starting Snapshot)

D_MUF_END_DATETIME

from S_MUF_DATETIME (ending Snapshot)

D_MUFTYPE

INTERVAL

D_MUF_TOTALROW

from S_MUF_TOTALROW (ending Snapshot)

D_MUF_DURATION

from D_MUF_START_DATETIME minus D_MUF_END_ DATETIME

Calculate counter values by subtracting the beginning Snapshot column value from the ending Snapshot value.