Re: Update via logfile

"Protime" <protime@dbn.lia.net> wrote: :Problem :- 6 regional offices all running Informix Standard engine with :databases varying in size from 2GB to 7GB. We want to maintain a separate :copy of each of these databases on a central machine, it is impractical to :copy and restore each of the databases in its entirety via the network :every night thus we are trying to update the central machine by moving the :daily logfile up to the central machine and rolling forward on each of the :relevant databases. However when the rollforward is actioned we get error :247 - unable to rollforward database. May be this should have worked. You would have to make sure the initial state of the databases are exactly similar though. : :Anyone have any suggestions? If you had used OnLine you could have used the built in replication to do this. With SE you might unload all data that changed during a day and load it on the sentral machine. To find this you might use a trigger to write to an "update" table what rows where inserted/updated/deleted during the day. You might also use timestamps on every row to find inserts and updates and save only deletes in such a table. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org