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

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). One option that has been proposed is to log all the transactions on each smaller system to tape during the day, then transmit (probably by ftp) the log files at close of business, and use them to update the central system's data. A similar process would be used at the end of the batch run to update the smaller systems with new data from the central system. So my questions are: - Is it possible to run the logical log from one Informix server against the data from another server, and expect all the same updates to occur? - Is it possible to take a log file, and separate it into smaller files, each one of which could be run against a different server? - or do I have to write a whole set of custom transaction logging routines to do this? - or is there another way? We don't want to use anything that involves a 2-phase commit over the network, since there are very stringent performance requirements for the local on-line systems, and since each system must be able to operate during the day even if the network or central server is down. Any advice greatly appreciated. Cheers Adam. -- ------------------------------------------------------------------------ | Adam Broun | Pointy birds. Oh, pointy pointy | | brouna@world.std.com | Annoint my head. Annointy Nointy | ------------------------------------------------------------------------