Re: Update via logfile

Posted in 1997

Joel Vannorsdel — Thu, 28 Aug 1997 10:02:03 -0500 — source: Informix-list mailing list archive (1991-1998)

Protime 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. > > Anyone have any suggestions? > > Thanks This problem sound like a cry for help from a replication company. The company I work for Praxis International has developed a suite of products to solve just this type of problem. From change based replication to a copy product we have it all. Our products not only support Informix but also Oracle, DB2/MVS, Sybase and MS SQLServer. Take a look at our home page at WWW.PRAXISINT.COM and see what you think. Joel Vannorsdel Joel_Vannorsdel@Praxisint.com