RE: Informix Server TIME different from NT Servers (daylight savi

Hi again, The servers have been 'bounced' (is bounced an Informix term for stop and restart the server?) many times as well as having been rebooted a number of times with no change in the time. ie. Informix's instance time is still out of sync with the server. Any one have any further ideas please? Is there a manual way to set whatever clock Informix is using? Regards, Bryce Stenberg. Harness Racing New Zealand computer department, emailto:bryce@hrnz.co.nz Phone: +64 3 3385099 -----Original Message----- From: John Harman [mailto:harmanj@agric.nsw.gov.au] Sent: Thursday, 5 October 2000 13:20 To: Bryce Stenberg Subject: Re: Informix Server TIME different from NT Servers (daylight savings) time?? On Thu, 5 Oct 2000, Bryce Stenberg wrote: > Hi All, > > I've just noticed on our Informix servers that the times are NOT in sync > with the server it is running on. > We use Windows NT4 SP6 for our servers. > The Informix versions are IDS 7.31 TC5 and IDS 7.30 TC9 (both 'for > Workgroups' editions). > We are in New Zealand and last Saturday night 'daylight savings' came into > effect. This advanced our clocks one hour for the summer months. Windows > NT automatically adjusted its time to match. > The Informix instances running on these servers have NOT adjusted - they > still have the old time. I can see this if I insert rows in a table with a > datetime column inserted using the CURRENT keyword, or similarly from a 4gl > program using an insert with the CURRENT keyword. Or even via the ISM > Inventory of log backups to tape. They all report a time one hour out of > sync! > > Does anyone know what I have to do to line up the Informix time to the > system time to take care of daylight savings adjustments? > > Can it be set to adjust automatically like Windows does when daylight > savings happen? - it happens twice a year after all. Bouncing the instance should get it re-read it's time from the server. We had the same trouble here in Australia. John CAUTION: This email message and accompanying data may contain information that is confidential and subject to legal privilege. If you are not the intended recipient you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you have received this email message in error please notify us immediately and erase all copies of the message and attachments. ALSO, unless expressly stated otherwise, the contents of this message represent only the views of the sender as expressed only to the intended recipient, do not commit Harness Racing New Zealand (HRNZ) to any course of action and are not intended to impose any legal obligation upon HRNZ.