If you are using SAS^® IT Service Vision (ITSV) or SAS^® IT Resource Management (ITRM) to process data from SunNet Manager, the calculations associated with Daylight Saving Time (DST) and the Greenwich Mean Time (GMT) Offset done after March 11, 2007 will be incorrect because of changes in the DST rules that took effect in 2007.

The following code should be used to change the options of any PDB that is used for SunNet Manager data. You can use it to change the options for any other PDB as well, but only the SunNet Manager collector references it.

This code creates a copy of the CPPDBOPT data set in the the DICTLIB library and then updates the CPDSTIME column in CPPDBOPT. Activate your PDB and submit this code to apply the new rule.

Note that any SunNet Manager PDB created after ITRM hot fixes 27IS04 (for 2.7) and 82IS09 (for 2.6) have been applied will *not* require this update to DICTLIB.

/* Create a backup of CPPDBOPT called CPPDBBAK */
data dictlib.cppdbbak;
   set dictlib.cppdbopt;
run;

/* Update the column CPDSTIME for the new 2007 Daylight Saving Time
rule */
data dictlib.cppdbopt;
   set dictlib.cppdbopt;

cpdstime="DHMS(MDY(3,15-WEEKDAY(MDY(3,14,YEAR(DATEPART(DATETIME)))),YEAR
(DATEPART(DATETIME))),3,0,0)<DATETIME<DHMS(MDY(11,8-WEEKDAY(MDY(11,7,YEAR
(DATEPART(DATETIME)))),YEAR(DATEPART(DATETIME))),2,0,0)";
run;

Operating System and Release Information

A fix for this issue for SAS IT Resource Management 2.7 is available at:

A fix for this issue for SAS IT Resource Management 2.6 is available at: