Re: Use of log files to update other On-Line Servers?

Adam M Broun (brouna@world.std.com) wrote: : I am trying to get a feel for whether the following scenario is possible : under Informix: : We are designing a system involving a large number (40-50) separate : Informix servers scattered over a state, with a larger, central system : that needs to perform some nightly batch functions on the data from all : the other servers, and needs to have mirrored data from each of the : smaller machines on a daily basis (not real time). etc..... I agree with the other #1 response that you can't get there from here, but you may want to look at Informix 6.0. They tout a "replication server" facility that is supposed to keep two machines synced by letting their log buffers talk to each other. I don't know whether or not you can work this type of deal with more than 2 machines, but knowing Informix, I'll bet against it. You're probably stuck with writing the transaction processor yourself, probably with some type of holding tables that hold daily changes and then post them to the central box. I doubt that you can get the info necessary to actually create log files to apply to a central machine.....you can use tblog to read logs, but I don't think you can make it write. The good/bad news is I don't know of any other database that will let you do it your way either..... -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in fall '94 from Prentice Hall ===========================================================================