Previous Topic: Output ParametersNext Topic: Examples of Creating Delta Summary Rowsets


How Date and Time Selection Is Processed

The DATERG and TIMERG parameters are applied to the rowset selection as individual selection pairs.

As each rowset is evaluated, it is first verified that the date portion of the D_MUF_END_DATETIME fits within the specified DATERG value. If the rowset qualifies for date selection, then the time portion of the D_MUF_END_DATETIME is verified that it fits within the TIMERG value.

The purpose of this process is to allow you to select certain time slices from certain days for processing.

For example, if you collect two snapshots each day at 0800 and 1700, the processing would generate Delta rowsets for the period from 1700 through the next day at 0800 and from 0800 through 1700. In this case, the Delta rowsets would represent the online day, 0800 to 1700, and the overnight processing, 1700 to 0800 (on the next day).

When creating SUMMARY, BASELINE, and AVGPERF rowsets, you can include the online day, the overnight processing, or both.

To process the online day only, the TIMERG would be 163000173000. This would allow for the 1700 (5 PM) snapshot to have occurred slightly before or after 1700. This selection would not select the time slices that ended at 0800 (8 AM).

To process only the overnight time slices (those that end at 0800), the TIMERG value would be specified as 073000083000.

To include both periods, specify TIMERG as 000000240000.

When processing Delta rowsets, the row must pass all selection criteria specified to be selected for processing. As mentioned earlier with delete processing for Delta rowsets, you may consider running a DELTARPT with the same selection criteria before you run the SUMMARY/BASELINE/AVGPERF function. The report would show the periods being selected and allow you to verify the selection criteria before creating the new Delta rowset.