Previous Topic: Next Snapshot for a Given MUF ExecutionNext Topic: Sample of Delta Rows


Last Snapshot for a given MUF execution

Generate one interval rowset as defined in the preceding section.

The DELTACRE function generates a "last" delta rowset. Each last Delta row is created with fixed values from the Snapshot row and counter values intact from the Snapshot row.

This last delta rowset represents the MUF processing done from Startup to last recorded Snapshot.

Row

Value

D_MUF_ENABLE

from S_MUF_ENABLE

D_MUF_START_DATETIME

from S_MUF_ENABLE

D_MUF_END_DATETIME

from S_MUF_DATETIME

D_MUFTYPE

LAST

D_MUF_TOTALROW

from S_MUF_TOTALROW

D_MUF_DURATION

from S_MUF_DATETIME minus S_MUF_ ENABLE

Copy corresponding Snapshot row counter values intact to Delta row.