5. FILES › 5.12 DB2 Package/DBRM Activity (DB2DPP) File › 5.12.3 DB2DPP Usage Considerations
5.12.3 DB2DPP Usage Considerations
This section identifies any special considerations or
techniques related to using the DB2DPP file.
Special Considerations/Techniques
o Care must be exercised in using the special date and
time data elements contained in each CA MICS file. As
the file's granularity increases in higher timespans,
certain fields lose significance and should not be
referenced.
- HOUR should not be used in MONTHS and YEARS.
- DAY and DAYNAME should not be used in WEEKS, MONTHS,
or YEARS.
- WEEK should not be used in MONTHS or YEARS.
- MONTH should not be used in YEARS.
o The data elements STARTTS and ENDTS have different
meanings when used in the DETAIL timespan versus their
meaning in the DAYS, WEEKS, MONTHS, and YEARS timespans.
The ENDTS and STARTTS, when appearing in the DAYS,
WEEKS, MONTHS, and YEARS timespans, indicate the span of
time over which the data has been summarized with
STARTTS indicating the lowest date and time and ENDTS
indicating the greatest date and time for the summarized
data.