Re: CDR and timestamps

Joel Vannorsdel wrote: > Usually the manner that this is controlled is by having a GMT offset on > each machine that is participating in replication. This way each > machine can provide the time corrected to GMT on an individual. Also > the time of an update usually does not affect other data. In the case > of an update to an existing row, how often would you have two different > users updating the same row at the same time. yes, rarely do users update the same row at the same time. But it is possible and if Informix hasn't resolved the issue then we're looking at two outcomes. 1) Informix Online didn't know what to do with the updates so it brought down CDR (best case scenario) or 2) It didn't know what to do with the updates but didn't bring down CDR so your data is now invalid and you don't know it (I've lived thru a similar bug in HDR with 7.11UC1). Either way I'm not happy. And the issue about daylight saving time is still open. What happens when you have two servers in different time zones and one switches to daylight savings time and the other doesn't. When server A changes it'ss time to one hour back does Serverr B think it's receiving transactions from an hour ago when they actually aren't. It doesn't matter if you use GMT or not. If you do, the transactions are now GMT-6 instead of GMT-5. Any input from Informix people would be nice. thanks,