V6-SERVER-G207 DATETIME in future will cause premature aging of data in PDB

In ITSV, the DATETIME variable is required for all tables. It is used as a primary key by which the data for a table is ordered, summarized and aged for each table within each level of the PDW (Performance Data Warehouse). If the raw data that is read into DATETIME has a value in the future, premature aging of the data from the PDW occurs at all levels of the PDW where AGELIMIT is greater than zero.

This has been a common problem for sites doing Y2K testing where the machine that the Y2K testing is done also provides data to be populated and summarized into the ITSV PDW.

Another problem identified with future data loaded into the PDW is with the input filtering logic. Input filtering maintains a datetime range for a specified interval for the collector type and by machine. If a range is built from future data that was loaded into the staged data, then that datetime range will not be processed again. For any questionsabout how to handle future data in your ITSV daily jobs, contact SAS Technical Support. There are some solutions available to ensure that future data is not loaded into the PDW.

THIS IS A YEAR 2000 READINESS DISCLOSURE.

System	Release Reported	Release Fixed
OS/390 (MVS)	6.09 TS450
Solaris	6.12 TS020
HP-UX Operating Systems	6.12 TS020
AIX/6000	6.12 TS020

No Fixes Available