USEOSTIME issue

Posted in 2007

Topics: Licensing & Editions, Platform-Specific Issues

STEPHEN SCOTT — Tue, 04 Dec 2007 21:15:19 — source: IIUG Forums & Mailing Lists

We have the following: IBM Informix Dynamic Server Version 10.00.FC6 HP-UX om4db1 B.11.11 U 9000/800 4126011100 unlimited-user license We started the database with USEOSTIME 0 When you do a date on the system it says the time is Tue Dec 4 15:09:58 CST 2007 But if you do a select first 1 current from systablesit returns 2007-12-04 16:09:58.000 Is there some unix setting I am missing or some informix time zone setting I'm missing? Stephen

↪ replying to STEPHEN SCOTT

Everett Mills — Tue, 04 Dec 2007 23:06:00 — source: IIUG Forums & Mailing Lists

> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > STEPHEN SCOTT > Sent: Tuesday, December 04, 2007 3:15 PM > To: ids@iiug.org > Subject: USEOSTIME issue [10590] > > We have the following: > IBM Informix Dynamic Server Version 10.00.FC6 > HP-UX om4db1 B.11.11 U 9000/800 4126011100 unlimited-user license > > We started the database with > > USEOSTIME 0> > When you do a date on the system it says the time is > > Tue Dec 4 15:09:58 CST 2007 > > But if you do a > > select first 1 current from systables> it returns > > 2007-12-04 16:09:58.000 > > Is there some unix setting I am missing or some informix time zone setting > I'm > missing? > > Stephen Try USEOSTIME 1, it's just as fast as USEOSTIME 0. Also, what does echo $TZ tell you? Did you apply the HP DST patch (PHCO_34668)? --EEM > > > ************************************************************************ ** > ***** > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Everett Mills

RALPH GENTRY — Wed, 05 Dec 2007 12:43:33 — source: IIUG Forums & Mailing Lists

Might want to login as the user who owns the oninit and see what timezone is set. I had this problem when setting a server for the UK but the machine was located in the US. Beieve there is also an environment variable that can or needs to be set.

↪ replying to RALPH GENTRY

STEPHEN SCOTT — Wed, 05 Dec 2007 16:40:11 — source: IIUG Forums & Mailing Lists

To all: The $TZ was correct but.... We found that Informix V10 uses a file on HP/UX /etc/default/tz The $TZ was set to CST but the /etc/default/tz was set to EST. Informix v9.4 seemed to use the $TZ value but informix V10 uses the /etc/default/tz file file. Our unix admin changed the /etc/default/tz file and informix immediatly changed the time returned in the sql. It also changed the timestamp in the online.log file. Thanks for the responses. Stephen