Re: Setting Unix System Time fools Informix

Greg McClure wrote: > > We are running Informix 7.20.UC2 on two DEC Prioris machines running SCO > 3.2.5.0. We are running with DRAUTO=2. Normal state is one machine On-line > Primary, the other Secondary. When we change the time on one of the Unix > boxes, Informix decides to make both machines Primary. Informix support say > this is something which cannot be avoided as the system time is exchanged > in the ping packets between the machines, and discrepancies will be > interpreted as one machine going down. > > My question is: Does anyone have a workaround for this problem ? We need to > attach our machines to a Time of Day Clock source from a satellite receiver > ! > > Greg McClure (CEM Systems Ltd) gmcclure@devel.cemsys.com Greg, Have you experimented with USEOSTIME in the onconfig file? From the comments in there I would guess that the server is keeping it's own clock instead of doing a time() system call. According to the comments it is slower to use the O/S time (probably because it is a system call rather than reading an int or something). However, I would think that if it is getting it's time from the system then changing the system time would not be a problem. Additionally, you may want to play with DRTIMEOUT to allow DR to be a little more flexible. -- scott dunbar g-bar limited partnership dunbar@hotjoe.com (home) chicago, il, usa scott@gbar.com (work) 312 362 4479