Re: CDR and timestamps

Vardan Aroustamian wrote: > > Jon C Vemo wrote: > > } At 11:11 PM 2/13/97 GMT, you wrote: > } >I just went to a user meeting here in NYC where informix had a talk > } >about CDR. I had a question regarding CDR, they didn't have the answer > } >then and I have not heard anything as of yet. Maybe somebody out there > } >can answer it for me. In the replication process, the timestamp is used > } >to see when this specific transaction occurred. Now here is my > } >question, what happens if the two servers are in different time zones, > } >does it get fooled by the difference in time? I belive this was an > } > } No. According to the class, and I just received the tape, so I will be > } verifying, > } but all the timestamps are converted and maintained as GMT, thus eliminating > } the issue with time zones. > } > } Now, the daylight savings time question, is one which I can not respond to > } as assuredly. I'll have to test this out. I presume this can/is accounted for. > } > } Jon > } > } >issue with HDR. Better yet, what happens when the servers are in > } >different timezones and one has daylight savings time and the other > } >doesn't? Does CDR go crazy when one server's time is adjusted and the > } >other isn't? > } > > } >thanks, > } > > } ---------------------------------------------------------------------------- > } Jon C. Vemo "Life is like a dogsled team, if you ain't the > } jvemo@cyberspace.com lead dog the scenery never changes." > } ---------------------------------------------------------------------------- > > Does this mean that for CDR used something other than ordinary > timestamp (which is the sequentially assigned number)? > > -- > vardan@sterling.ru > Vardan Aroustamian > Sterling Group, Moscow, Russia 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.