DST
2007 Updates for Sagitta, AIX and NTSAGITTA
Change in Daylight
Saving Time Start and End Dates in 2007
In the United States, the start and end dates for daylight saving
times are being changed in 2007. Daylight saving time will now start
on March 11, 2007 (rather than in early April) and will end on
November 4, 2007 (rather than in late October). Canada has also
decided to follow the same schedule. .
As a result of this change in the start and end dates for Daylight
Saving Time, you may need to make some changes to the AIX setup of
your database server (RS6000). The Sagitta application gets its time
stamp from the AIX operating system. The time stamp is used in the
AUDIT string that is written each time a data record is updated. The
time itself may not be a serious factor in terms of data or from an
insurance perspective but if you require it to be completely correct
to run back ups or scheduled maintenance, there are patches
available. You may also need to make changes to your Web (IIS)
server. Again, the time is not at all critical for the application
but only for scheduled maintenance activities. The following
procedures will guide you through this.
Regarding the Database Server (RS6000)
AIX Technology Levels refer to twice yearly updates that provide
new software and hardware features. The first Technology Level of
the year focuses on hardware and new adapters being introduced.
The second Technology Level of the year includes both hardware and
software enhancements.
In response to the change in the Daylight Savings Time schedule,
systems running AIX 5.2 or 5.3 can install specific Technology Level
releases to address this issue.
A system running on AIX 5.2 will need to have Technology Level 8
installed. A system running AIX 5.3 will need to have Technology
Level 4 installed.
To determine the current Technology level of a system, perform the
following:
1. Login as root user
2. Type oslevel –r
An example of the output from this command would be 5100-04. The
number after the dash, in this case 04, determines the Technology
Level.
Technology Level 8 for AIX 5.2 can be found here:
http://www14.software.ibm.com/webapp/set2/abl/fixinfo?release=52&b=5200-08
Technology Level 4 for AIX 5.3 can be found here:
http://www14.software.ibm.com/webapp/set2/abl/fixinfo?release=53&b=5300-04
Each of these sites will provide procedures to download and install
the requested Technology Level upgrade.
If you are not on 5.2 or 5.3 or able to perform these steps in time,
the following manual procedure can be performed. If this procedure
is followed, Sagitta release 65966 must be applied immediately
after.
Release 65966 is required in order to schedule a recurring file save
or purge, or to reschedule a current recurring file save. Release
65966 can be loaded on either a 65900 or 70900 Sagitta system.
To update your server, do the following:
Log in as root
At the AIX prompt (#), type one of the following commands depending
on your time zone:
chtz EST5EDT,M3.2.0,M11.1.0 if you are in the Eastern Time Zone
or
chtz CST6CDT,M3.2.0,M11.1.0 if you are in the Central Time Zone
or
chtz MST7MDT,M3.2.0,M11.1.0 if you are in the Mountain Time Zone
or
chtz PST8PDT,M3.2.0,M11.1.0 if you are in the Pacific Time Zone
Once you return to the AIX prompt after running the command, you
should reboot your system for the time zone change to take effect.
You can do this typing
uv –admin –stop <Enter>
shutdown –Fr <Enter>
After your machine has rebooted:
Load and apply release 65966
Perform an AIX backup (see System Management Guide for procedures)
Regarding the Web Server (IIS)
Microsoft has authored a page on its web site that discusses the DST
change as it relates to Microsoft products. The page can be found
here:
http://www.microsoft.com/windows/timezone/dst2007.mspx
Microsoft offers a download to address the DST change for Windows
2003 Server either through the Download or Knowledge Base Article
928388. The page for Knowledge Base article 928388 can be found
here:
http://support.microsoft.com/kb/928388
Regarding Windows 2000 Server, a download to address the DST change
is not available without Extended Hotfix Support. The DST issue can
be addressed by:
1. Following the procedures in Knowledge Base article 914387 found
here: http://support.microsoft.com/kb/914387
2. Downloading and running the tzedit.exe utility found here:
http://download.microsoft.com/download/5/8/a/58a208b7-7dc7-4bc7-8357-28e29cdac52f/TZEDIT.exe
