Re: Replication on INFORMIX ?

Bharat, I am currently using Informix 7.23 to replicate between NT and DEC Unix. We are using 7.23 because we require Update Anywhere replication. We were using 7.22 in the same environment to do one way replication before the Update Anywhere requirement. My hardware environments are totally different. My Informix environments are totally different. Different number of chunks, different dbspace names and different number of databases. When you specify the replicate you supply a select statement. This select statement is used to determine what is being replicated, I believe this select statement can be any valid select. To set up replication using 7.23 I had to have a NT workstation setup with SNMP and the Informix replication manager software installed. I was later told about some C programs, in the $INFORMIXDIR/demo/cdrapi directory, that call replication API's. These may help you if you want to automate the replication setup. You will need to go through the release notes carefully to avoid any platform specific issues. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Replication on INFORMIX ? Author: "Bharat Onso" <magician@indosat.net.id> at WCA-INET Date: 08/12/97 12:38 PM Hi Guys, I'm new in this nw and need u'r help ... we're trying Informix Dymanic Server 7.22 on SCO and soon also for our SUN Solaris ... it's running well but I have difficulties with the REPLICATION Features ... this's actually the reason we migrated to SQL my quez are : (as seen at page 236, Unleashed Informix by John Mc.Nally, Glenn Miller, SAMS Publishing) - the hardware servers must be identical .... - software version must be identical - amount of dbspace/disk space must be equal - ROOTNAME, ROOTPATH, ROOTOFFSET, ROOTSIZE must be identical on both servers - PHYSDBS, PHYSFILE must be identical .. - etc ( both machine must be identical ) do we need this .... I mean actually this is a mirroring ... not a replication enginee ... right? and also in replication ... we need not to replicate the whole database ... only some tables ...and also the hardware and o/s are different ... .... as I have seen in other databases ) so any idea about this ... ? ... someone please help me on this ... I already tried to get contact with the informix guys ... and also the distributor here ...but they' were giving me quite funny answer and asking more time for further answers ... what I need to know is : - could we replicate some tables only - do we need identical machine, o/s, equal space, etc - how to do the setup ... we this this quite soon .. very soon tia regards Bharat / MK