Daylight Savings Time....
A user asked whether the 2007 US/Canada DST rule change would break datetime storage or date arithmetic in IDS 7.24 (HP-UX) and 7.31 (Linux), beyond patching the OS clock. Replies said IDS simply takes date/time from the OS, so patching the OS (and JVM/JRE if Java is used) is sufficient; IDS date arithmetic doesn't adjust for DST anyway. Links to IBM's DST alert/flash and the JTZU tool were posted, noting APARs IC50989 (IDS 10.00) and IC50990 (9.40), with no action needed for 7.3x and earlier. A follow-up question about detecting inadvertent Java procedure use went unanswered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Given the new government regulations, I haven't seen much mention of what problems will be caused with Informix with stored datetime sensitive or datetime calculation sensitive operations. For Y2K, our Informix was quite stable, but on Feb 29th, 2000, the year to date calculations below up because of some internal calculations within Informix couldn't find Feb 29th 1999 (and didn't use Feb 28th 1999 like the other databases). As an IDS 7.24 (HP-UX 10.xx) and IDS 7.31 (Linux) shop, are there any known problems or 'fixes' other than setting the system date in UNIX and LINUX? Thanks, Larry (work) l.timmins@medmal.com
If your OS is patched (and JVM/JRE as required) then IDS will be fine Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of LARRY TIMMINS > Sent: 20 February 2007 08:29 > To: ids@iiug.org > Subject: Daylight Savings Time.... [8436] > > Given the new government regulations, I haven't seen much > mention of what problems will be caused with Informix with > stored datetime sensitive or datetime calculation sensitive > operations. > > For Y2K, our Informix was quite stable, but on Feb 29th, > 2000, the year to date calculations below up because of some > internal calculations within Informix couldn't find Feb 29th > 1999 (and didn't use Feb 28th 1999 like the other databases). > > As an IDS 7.24 (HP-UX 10.xx) and IDS 7.31 (Linux) shop, are > there any known problems or 'fixes' other than setting the > system date in UNIX and LINUX? > > Thanks, > Larry > > (work) l.timmins@medmal.com > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the > discussion forum.
IBM has this to say so far: http://www.ibm.com/support/alerts/us/en/daylightsavingstimealert.html
Larry, DATE and DATETIME just store the current date &/or time as returned by the OS. The time calculations (ex: DATETIME(2007-03-30 10:10:10) YEAR TO SECOND + (30) UNITS DAY) do not adjust for DST now, so they are not adversely affected by the change in the start day except that several more weeks worth of calculated times will be off by an hour. 8-( Art S. Kagel ----- Original Message ----- From: Larry Timmins <ids@iiug.org> At: 2/20 9:29:48 Given the new government regulations, I haven't seen much mention of what problems will be caused with Informix with stored datetime sensitive or datetime calculation sensitive operations. For Y2K, our Informix was quite stable, but on Feb 29th, 2000, the year to date calculations below up because of some internal calculations within Informix couldn't find Feb 29th 1999 (and didn't use Feb 28th 1999 like the other databases). As an IDS 7.24 (HP-UX 10.xx) and IDS 7.31 (Linux) shop, are there any known problems or 'fixes' other than setting the system date in UNIX and LINUX? Thanks, Larry (work) l.timmins@medmal.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Larry, Here is the online flash document for IBM IDS DST issues. If you have a= ny questions after reviewing the site, please contact IBM Informix support= . http://www-1.ibm.com/support/docview.wss?rs=3D630&context=3DSSGU8G&cont= ext=3DSSHPYE&dc=3DD600&uid=3Dswg21248851&loc=3Den_US&cs=3DUTF-8&lang=3D= en Here is the page to download the JTZU tool from: http://www-128.ibm.com/developerworks/java/jdk/dst/index.html Additional related URLs. http://www-306.ibm.com/software/data/informix/ids/support/ http://www.ibm.com/support/alerts/daylightsavingstimealert.html Thank you, Roger Kee = "LARRY TIMMINS" = <ltimmins@optonli = ne.net> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Daylight Savings Time.... [8436= ] 02/20/2007 09:29 = AM = = = Please respond to = ids@iiug.org = = = Given the new government regulations, I haven't seen much mention of wh= at problems will be caused with Informix with stored datetime sensitive or= datetime calculation sensitive operations. For Y2K, our Informix was quite stable, but on Feb 29th, 2000, the year= to date calculations below up because of some internal calculations within= Informix couldn't find Feb 29th 1999 (and didn't use Feb 28th 1999 like= the other databases). As an IDS 7.24 (HP-UX 10.xx) and IDS 7.31 (Linux) shop, are there any k= nown problems or 'fixes' other than setting the system date in UNIX and LINU= X? Thanks, Larry (work) l.timmins@medmal.com ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
It takes awhile but there looks like two updates if you go down the IBM DST postings. IDS versions 7.3x and earlier are okay. IDS 9 and 10 all need updates (see below link or APARs listed at end of note) ------------------------------------- Here is the lastest posting: http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSHPYE&dc =D600&uid=swg21248851&loc=en_US&cs=UTF-8&lang=en Abstract UPDATED 01/15/2006: In March 2007, the effective dates of DST in the U.S. and Canada will change. You must take action to address this issue if you are using IBM® IDS® for Linux®, UNIX®, and Windows®. 11/16/2006 Revised: * Updated version 10 and 9.4 information regarding how to identify the use of Java procedures. * Added information for version 9.3 and 9.2. 01/15/2006 Revised: * Added information for version 7.3. * Added information for Digital Unix and SGI 9.4 versions. 02/07/2006 Revised: * Added HP-UX specific information for version 9.4. * Updated Tru64 and IRIX information. ... Important: If you are using JAVA for your application development, you may need to upgrade the JDK version you are using for development. Contact your vendor regarding updates. The APARs reported for this situation are: Product APAR IBM® IDS® version 10.00 IC50989 IBM® IDS® version 9.40 IC50990 No action is required for IBM IDS versions 7.3x and earlier.
We are not using Java or Java stored procs (that we know of). Will
"onstat -g prc" show any of the built-in procedures that we might
inadvertently be calling?
Bob Roussey
Unix / Informix Administration
Spirit Airlines
Robert.Roussey@SpiritAir.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
LARRY TIMMINS
Sent: Tuesday, February 20, 2007 9:54 AM
To: ids@iiug.org
Subject: Re: Daylight Savings Time.... [8444]
It takes awhile but there looks like two updates if you go down the IBM
DST
postings.
IDS versions 7.3x and earlier are okay.
IDS 9 and 10 all need updates (see below link or APARs listed at end of
note)
-------------------------------------
Here is the lastest posting:
http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=S
SHPYE&dc=D600&uid=swg21248851&loc=en_US&cs=UTF-8&lang=en
Abstract
UPDATED 01/15/2006: In March 2007, the effective dates of DST in the
U.S. and
Canada will change. You must take action to address this issue if you
are
using IBM(r) IDS(r) for Linux(r), UNIX(r), and Windows(r).
11/16/2006 Revised:
* Updated version 10 and 9.4 information regarding how to identify the
use of
Java procedures.
* Added information for version 9.3 and 9.2.
01/15/2006 Revised:
* Added information for version 7.3.
* Added information for Digital Unix and SGI 9.4 versions.
02/07/2006 Revised:
* Added HP-UX specific information for version 9.4.
* Updated Tru64 and IRIX information.
....
Important: If you are using JAVA for your application development, you
may
need to upgrade the JDK version you are using for development. Contact
your
vendor regarding updates.
The APARs reported for this situation are:
Product APAR
IBM(r) IDS(r) version 10.00 IC50989
IBM(r) IDS(r) version 9.40 IC50990
No action is required for IBM IDS versions 7.3x and earlier.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Related threads
- Column name length in Informix
- Caching Data to Buffers
- Checkpoint Duration
- dbaccess standalone.
- Getting executable name.