Previous Topic: Example JCLNext Topic: When to Use


Process a Snapshot Rowset into a Delta Rowset

A Delta is the calculated difference between two Snapshots taken of the same MUF instance. When calculating a Delta, the beginning date and time are taken from the beginning Snapshot, while the ending date and time are taken from the ending Snapshot. The duration column is the number of hours between the beginning and ending date/times. The value of a character column or fixed value column is selected from the ending Snapshot. When calculating a Delta of a counter column, the result is the value of the ending Snapshot minus the value of the starting Snapshot. Counter values can be zero, but they cannot be a negative value.