Re: timezones

From: rcsaxon@aol.com (RCSAXON) > >We are installing a fairly large system where one Informix server is going >to >support multiple clients covering several timezones. The problem is how to >get >the system to correctly time-stamp transactions that reflect the time zone >where the source client resides. So far the only suggestions is to rewrite >all >of our code to generate date/time at the client side and attach it to the >transaction before introduction to the server and not rely on the server >for >any time-stamping. There must be an easier way to address this problem. >Certainly, one approach is to establish several Informix servers on one >system >and dedicate each server to the cluster of clients in a particular timezone >and >setting the TZ in that user space. This is not useful because the data >must be >shared by all clients. > >Any suggestions??? Intriguing. I have some suggestions, whether they are practical or not is, of course, another matter entirely. 1. You can use Enterprise Replication to allow multiple servers in various regions to share the data. it may not be 100% real time, but it should be very close, provided your network is up to this. [Disclaimer: I haven't tried this myself! :-] 2. You might have some sort of enviroment variable in SETNET that you might be able to pass back, indicating the time zone. [Disclaimer: I haven't tried this either! :-] Given a choice, I'd probably go for 1. I'm sure one of the more intelligent folks here could contribute something useful. [Art!! :-] ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com