Re: Data Replacation using Informix Online 5.01

> I am running Informix ONline 5.01 on an HP/9000 runing 9.04. I also have > another HP/9000 running 9.04, and would like to use one machine for all > of our interactive users, and the other machine for running reports. > > I know this can be done using 6.0, but I am forced to stay with 5.01 > until a software vendor catches up with the informix versions. > > I thought about using an archive process, and reloading the data from > archive each night, but the disk structure on the machines don't match > and makes restores from archives impossible. It would be nice if I could > do something like take the transaction log file from the primary machine, > and roll the transactions on to the reporting machine, but I havn't been > able to figure out how to bypass the archive process here either. > > Any suggestions would be greatly appreciated. > > Thanks in advance. > If the number of tables you're replicating is small enough to make it manageable, I'd suggest you set up a distributed database environment and use simple SQL-based programs to do the transfers. You'd have to add a flag on the source table to mark the update as completed, and use transactions to prevent the flag update from committing until you're sure sure the insert/ update worked. Data replication as implemented in OnLine 6/7 is really designed to be a fault tolerance feature, not so much for what you're doing. Alternatively, why not just have the users on the reporting machine query the database on the other box, over I-Star? Easier still. (Provided the connection between the boxes is reliable). > John Addie > SysAdmin > WRQ akent@cix.compulink.co.uk (Andy Kent) -------------------------------------