Data Replication between diferent versions of IDS.

Can somebody tell me if is possible data replication between diferent versions of Informix Dynamic Server? I have two hosts: One has IDS 7.30 FC7 and the other has IDS 2000 9.20 UC1. Each host permit connections for shared memory and for tcp with sockets. (onipcshm and onsoctcp) ; the definitions on sqlhosts file, host file, host_equiv,.rhost and services are corrected because I can connect to the hosts in dbaccess utility. I've defined two entrys more on each sqlhosts file for data replication . This entrys are "groups". Each group belong to the connections for one host: sqlhost files: (are equal in 2 hosts). dbservername nettype host servicename options g_atlas group - - e=atlas_tcp,i=1 atlas_sh onipcshm atlas atlas_sh atlas_tcp onsoctcp atlas atlas_tcp g_alfa group - - e=alfa_tcp,i=2 alfa_sh onipcshm alfa alfa_sh alfa_tcp onsoctcp alfa alfa_tcp Then I've tried to configure data replication between 2 groups of servers. Really I need only unidirettional replication (primary to target): for alfa to atlas; but I don't know how do this. I've use the CLU to try configure the replication. I've defined the two servers ( or only I need define the primary server and no the target server?) with the CLU in alfa host: "cdr def server --init g_alfa --ats=/usr/informix/cdr_alfa/ats_alfa -R /usr/informix/cdr_alfa/ris_alfa" -> OK The IDS create the syscdr database and the syscdr* views on sysmaster database on host alfa "cdr def server --connect g_atlas --init g_atlas --ats=/usr/informix/cdr_atlas/ats_atlas -R /usr/informix/cdr_atlas/ris_atlas " -> OK The IDS create the syscdr database and the syscdr* views on sysmaster database on host atlas Then, I define the replication with: " cdr define repl --connect=g_alfa -C ignore repl1 "asemas@g_beta:ceinsa.arquitecto" "select * from arquitecto" -> OK Really I want to define the unidirettional replication from alfa to atlas. Finally I start the replication with "cdr start repl --connect=g_alfa repl1" If I execute "cdr list server": SERVER ID STATE STATUS CONNECTION CHANGED ---------------------------------------------------------------------------- - g_alfa 2 Active Local If I execute "cdr list server -c g_atlas": SERVER ID STATE STATUS CONNECTION CHANGED ---------------------------------------------------------------------------- - g_atlas 1 Active If I execute "cdr list repl": REPLICATE STATE CONFLICT FREQUENCY OPTIONS ---------------------------------------------------------------------------- repl1 ACTIVE ignore immediate row All is Ok; but when I make an insert into the arquitecto table on server alfa, no replication occurrs to server atlas and the online.log on server alfa is : 18:11:14 CDR Queuer: Is suspended failed gc_queryGroup servers returned 0!! for group/repl: 131073, commit time: 959789473, send time: 959789473, ret code: 0. 18:11:14 CDR Grouper Evaluator could not give buffer to Queuer. What is THIS?. May be a problem with the dbspaces???? Thank You and sorry for my poor english.

You can replicate (ER) from 7.30 to 9.2, but I'd really rather see a customer on 7.31 instead of 7.30. You almost have the sqlhosts file correct. You need to add a g= option for the tcp entry in each of the groups. Also, what you have actually done is to create two enterprises, one on each of your groups. For all but the first server that you define, you must have a -S option on the define server that you are 'syncing' to. What that really means is to identify a server that is already in the enterprise from which you will copy the syscdr database. If you do not do this, then you are simply defining the initial server in a new enterprise. Luisma Sanchez wrote: > Can somebody tell me if is possible data replication between diferent > versions of > Informix Dynamic Server? > > I have two hosts: One has IDS 7.30 FC7 and the other has IDS 2000 9.20 UC1. > > Each host permit connections for shared memory and for tcp with sockets. > (onipcshm and onsoctcp) ; the definitions on sqlhosts file, host file, > host_equiv,.rhost > and services are corrected because I can connect to the hosts in dbaccess > utility. > > I´ve defined two entrys more on each sqlhosts file for data replication . > This entrys are > "groups". Each group belong to the connections for one host: > > sqlhost files: (are equal in 2 hosts). > > dbservername nettype host servicename options > > g_atlas group - - e=atlas_tcp,i=1 > atlas_sh onipcshm atlas atlas_sh > atlas_tcp onsoctcp atlas atlas_tcp > g_alfa group - - e=alfa_tcp,i=2 > alfa_sh onipcshm alfa alfa_sh > alfa_tcp onsoctcp alfa alfa_tcp> > Then I´ve tried to configure data replication between 2 groups of servers. > Really I need only unidirettional replication (primary to target): for alfa > to atlas; but I don´t know how do this. > I´ve use the CLU to try configure the replication. > > I´ve defined the two servers ( or only I need define the primary server and > no the target server?) > with the CLU in alfa host: > "cdr def server --init > g_alfa --ats=/usr/informix/cdr_alfa/ats_alfa -R > /usr/informix/cdr_alfa/ris_alfa" -> OK > > The IDS create the syscdr database and the syscdr* views on sysmaster > database on host alfa > > "cdr def server --connect g_atlas --init > g_atlas --ats=/usr/informix/cdr_atlas/ats_atlas > > -R /usr/informix/cdr_atlas/ris_atlas " -> OK > > The IDS create the syscdr database and the syscdr* views on > sysmaster database on host atlas > > Then, I define the replication with: > " cdr define repl --connect=g_alfa -C ignore repl1 > "asemas@g_beta:ceinsa.arquitecto" > "select * from arquitecto" -> OK > > Really I want to define the unidirettional replication from alfa to atlas. > > Finally I start the replication with "cdr start repl --connect=g_alfa repl1" > > If I execute "cdr list server": > > SERVER ID STATE STATUS CONNECTION CHANGED > ---------------------------------------------------------------------------- > - > g_alfa 2 Active Local > > If I execute "cdr list server -c g_atlas": > > SERVER ID STATE STATUS CONNECTION CHANGED > ---------------------------------------------------------------------------- > - > g_atlas 1 Active > > If I execute "cdr list repl": > > REPLICATE STATE CONFLICT FREQUENCY OPTIONS > ---------------------------------------------------------------------------- > repl1 ACTIVE ignore immediate row > > All is Ok; but when I make an insert into the arquitecto table on server > alfa, no > replication occurrs to server atlas and the online.log on server alfa is : > > 18:11:14 CDR Queuer: Is suspended failed gc_queryGroup servers returned 0> !! > for group/repl: 131073, commit time: 959789473, send time: 959789473, ret > code: 0. 18:11:14 > CDR Grouper Evaluator could not give buffer to Queuer. > > What is THIS?. May be a problem with the dbspaces???? > > Thank You and sorry for my poor english. -- Madison Pruet =========================================== Enterprise Replication Product Developement Dallas, Texas Informix Software ===========================================