SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 19685: ITSV/ITRM Daylight Saving Time changes for SunNet Manager

DetailsHotfixAboutRate It

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

Product FamilyProductSystemReported ReleaseFixed Release*
SAS SystemSAS IT Management Solutions Core Components MVA DataMicrosoft Windows NT Workstation2.7
Microsoft Windows 2000 Server2.7
Microsoft Windows 95/982.7
Microsoft Windows 2000 Professional2.7
Microsoft Windows 2000 Datacenter Server2.7
Microsoft Windows 2000 Advanced Server2.7
Solaris2.7
z/OS2.7
64-bit Enabled Solaris2.7
64-bit Enabled HP-UX2.7
Linux2.7
HP-UX2.7
64-bit Enabled AIX2.7
Tru64 UNIX2.7
AIX2.7
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.