ADJUSTINTERVAL

For type 30 record, by default, UIE selects records that have a time stamp within the range of 24 hours before the start date/time and 24 hours after the end date/time. This allows UIE to capture data for batch jobs that may have started or ended outside the user specified interval. The 24 hour default can be changed by the ADJUSTINTERVAL command.

Type 101/239 SMF records contain data for Db2 packages that are accessed by a Db2 plan. UIE matches the type 101/239 package records to their corresponding type 101/3 plan record. Type 101/239 package records are normally written to the SMF data set before their corresponding type 101/3 plan record. The UIE default is to select all type 101/239 package records that match the user specified interval, with one hour subtracted from the start time and one hour added to the end time.

Syntax

Syntax explanation

nnnn specifies the number of hours that are used to adjust the start and end date/time for the type 30 or 101/239 record selection. This can be a number between 0 and 9999. Specify the keyword ALL to select ALL type 30 or 101/239 records.

Example

In this example the user specified interval is 0000 - 2400 on January 29, 2019. The selection interval for the type 30 records is extended by 48 hours for both the start and end time. The selection interval for the type 30 records would have a start time of 0000 on January 27, 2019 and an end time of 2400 on January 31, 2019. The selection interval for the type 101/239 records extends by 2 hours for both the start and end time. The selection interval for the type 101/239 records have a start time of 2100 on January 28, 2019 and an end time of 0300 on January 30, 2019.