Changes to Daylight Savings Time in 2007 may affect your databases (DB2, Oracle and others)

Changes to Daylight Savings Time in 2007 may affect your databases (DB2, Oracle and others): "In the United States the start and end of daylight savings times are being changed in 2007. Daylight savings time will now start on March 11, 2007 (rather than early April) and will end on November 4, 2007 (rather than late October). Canada has also decided to follow the same schedule. This may impact your databases so read on.

DB2, and other data servers, rely on the operating system clock to get the current date and time. There will of course be an operating system patch that you will have to apply to virtually all operating systems so that they will know of the time change. And internally, logs don't use time zone information (in DB2, Oracle or any other DB that I'm aware of) so there is no problem there. But there is one more issue to know about. Java SDK and JRE need a special patch. Without this patch your Java applications that work with timestamps will display the wrong time during the weeks of the changed DST. And if the Java application uses that time stamp (for scheduling purposes for example) they will behave incorrectly during this extended DST time. This includes your own Java Applications (and your JDBC applications) as well as the DB2 Control Center and Query Patroller.

Here is a link to more information and the patches that are available or will be available. This site also has links to the operating system patches for AIX, Solaris, HP-UX, Windows, and Linux."