informix enterprise replication

Posted in 2004

BART DE TANDT — Tue, 23 Mar 2004 07:34:26 — source: IIUG Forums & Mailing Lists

Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This replication works just fine. I also defined a replication between 3 and 4 . This replication also works fine. But when I insert a new record in 1-2, this is replicated to the central pc (3) but cannot be found in pc 4 (although the replication between 3 and 4 works perfect). It looks like when a change occurs in 3 that comes from the replication with (1-2) it isn't seen by the replication with 4. I also noticed another problem : when my primary server from hdr drops and the secondary takes over the work, and then the primary comes back. All the changes are written to the primary but are not sent to the central? Although these tables are in a replication. Is this normal ? Can anybody help me here ?? Thx in advance !!

↪ replying to BART DE TANDT

Colin Bull — Tue, 23 Mar 2004 10:27:15 — source: IIUG Forums & Mailing Lists

BART DE TANDT wrote > I have 4 servers. > > 1 + 2 -> setup hdr > 3 -> central > 4 -> upper level > > I defined a replication between 1-2 group and the central > group. This replication works just fine. > I also defined a replication between 3 and 4 . This > replication also works fine. But when I insert a new record > in 1-2, this is replicated to the central pc (3) but cannot > be found in pc 4 (although the replication between 3 and 4 > works perfect). It looks like when a change occurs in 3 that > comes from the replication with (1-2) it isn't seen by the > replication with 4. > > I also noticed another problem : when my primary server from > hdr drops and the secondary takes over the work, and then the > primary comes back. All the changes are written to the > primary but are not sent to the central? Although these > tables are in a replication. > > Is this normal ? Replication does not normally work on a replicated record, UNLESS you have set server 4 up as a leaf server. I have not done that yet, so do not know the command. Colin Bull c.bull@videonetworks.com

↪ replying to BART DE TANDT

Madison Pruet — Tue, 23 Mar 2004 17:04:29 — source: IIUG Forums & Mailing Lists

--0__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6 Content-type: multipart/alternative; Boundary="1__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6" --1__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable When the HDR pair in 9.4 switch, we are not able to automatically start= ER on the new primary because we do not know if it became standard because= of an HDR failover, or because the HDR pair was being split into two independent servers. So you may have to issue a 'cdr start' command on= the new standard. M.P. = "BART DE TANDT" = <zwinne_machinne@ To: ids@iiug.org = pandora.be> cc: = Sent by: Subject: informix enter= prise replication [2712] forum.subscriber@ = iiug.org = = = 03/22/2004 11:34 = PM = = Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This replication works just fine. I also defined a replication between 3 and 4 . This replication also wo= rks fine. But when I insert a new record in 1-2, this is replicated to the central pc (3) but cannot be found in pc 4 (although the replication between 3 and 4 works perfect). It looks like when a change occurs in 3= that comes from the replication with (1-2) it isn't seen by the replica= tion with 4. I also noticed another problem : when my primary server from hdr drops = and the secondary takes over the work, and then the primary comes back. All= the changes are written to the primary but are not sent to the central? Although these tables are in a replication. Is this normal ? Can anybody help me here ?? Thx in advance !! = --1__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> When the HDR pair in 9.4 switch, we are not able to automatically st= art ER on the new primary because we do not know if it became standard = because of an HDR failover, or because the HDR pair was being split int= o two independent servers. So you may have to issue a 'cdr start' comm= and on the new standard. M.P. <img src=3D"cid:10__=3D07BBE4F3DFCEB0D68f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "BART DE TANDT= " <zwinne_machinne@pandora.be>">"BART DE TANDT" &l= t;zwinne_machinne@pandora.be> <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D07BBE4F3DFCE= B0D68f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D07BBE4F3DFCEB0D68f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D07BBE4F3DFCEB0D68f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>"BART DE TANDT" <zwinne_machinne@p= andora.be> Sent by: forum.subscriber@iiug.org 03/22/2004 11:34 PM</ul> </ul> </ul> </ul> </td><td width=3D"100%"><img src=3D"cid:20__=3D07BBE4F3DFCEB0D68f9e8a93= df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> To: ids@iiug.org cc: Subject: informix enterprise = replication [2712]</td></tr> </table> <tt>Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This r= eplication works just fine. I also defined a replication between 3 and 4 . This replication also wo= rks fine. But when I insert a new record in 1-2, this is replicated to = the central pc (3) but cannot be found in pc 4 (although the replicatio= n between 3 and 4 works perfect). It looks like when a change occurs in= 3 that comes from the replication with (1-2) it isn't seen by the repl= ication with 4. I also noticed another problem : when my primary server from hdr drops = and the secondary takes over the work, and then the primary comes back.= All the changes are written to the primary but are not sent to the cen= tral? Although these tables are in a replication. Is this normal ? Can anybody help me here ?? Thx in advance !! </tt> </body></html>= --1__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6-- --0__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=07BBE4F3DFCEB0D68f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=07BBE4F3DFCEB0D68f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=07BBE4F3DFCEB0D68f9e8a93df938690918c07BBE4F3DFCEB0D6 Content-type: image/gif; name="pic03439.gif" Content-Disposition: inline; filename="pic03439.gif" Content-ID: <30__=07BBE4F3DFCEB0D68f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23

↪ replying to BART DE TANDT

Madison Pruet — Tue, 23 Mar 2004 18:51:16 — source: IIUG Forums & Mailing Lists

--0__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C Content-type: multipart/alternative; Boundary="1__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C" --1__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable I may have misread your original email. ER does not support what is sometimes called cascading replication. If= you want to replicate between 1->2, then you define a replicate between 1 a= nd 2. If you then define a replicate between 2->3, that will only be replicated if the client does the data change on server 2. It will not= forward a replicated row which was originally inserted on server 1. In= order to replicate from 1 -> 2 and from 1->3, you must define the repli= cate as having three participants. = "BART DE TANDT" = <zwinne_machinne@ To: ids@iiug.org = pandora.be> cc: = Sent by: Subject: informix enter= prise replication [2712] forum.subscriber@ = iiug.org = = = 03/22/2004 11:34 = PM = = Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This replication works just fine. I also defined a replication between 3 and 4 . This replication also wo= rks fine. But when I insert a new record in 1-2, this is replicated to the central pc (3) but cannot be found in pc 4 (although the replication between 3 and 4 works perfect). It looks like when a change occurs in 3= that comes from the replication with (1-2) it isn't seen by the replica= tion with 4. I also noticed another problem : when my primary server from hdr drops = and the secondary takes over the work, and then the primary comes back. All= the changes are written to the primary but are not sent to the central? Although these tables are in a replication. Is this normal ? Can anybody help me here ?? Thx in advance !! = --1__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> I may have misread your original email. ER does not support what is sometimes called cascading replication. If= you want to replicate between 1->2, then you define a replicate bet= ween 1 and 2. If you then define a replicate between 2->3, that wil= l only be replicated if the client does the data change on server 2. I= t will not forward a replicated row which was originally inserted on se= rver 1. In order to replicate from 1 -> 2 and from 1->3, you mus= t define the replicate as having three participants. <img src=3D"cid:10__=3D07BBE4F3DFF56B5C8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "BART DE TANDT= " <zwinne_machinne@pandora.be>">"BART DE TANDT" &l= t;zwinne_machinne@pandora.be> <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D07BBE4F3DFF5= 6B5C8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D07BBE4F3DFF56B5C8f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D07BBE4F3DFF56B5C8f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>"BART DE TANDT" <zwinne_machinne@p= andora.be> Sent by: forum.subscriber@iiug.org 03/22/2004 11:34 PM</ul> </ul> </ul> </ul> </td><td width=3D"100%"><img src=3D"cid:20__=3D07BBE4F3DFF56B5C8f9e8a93= df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> To: ids@iiug.org cc: Subject: informix enterprise = replication [2712]</td></tr> </table> <tt>Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This r= eplication works just fine. I also defined a replication between 3 and 4 . This replication also wo= rks fine. But when I insert a new record in 1-2, this is replicated to = the central pc (3) but cannot be found in pc 4 (although the replicatio= n between 3 and 4 works perfect). It looks like when a change occurs in= 3 that comes from the replication with (1-2) it isn't seen by the repl= ication with 4. I also noticed another problem : when my primary server from hdr drops = and the secondary takes over the work, and then the primary comes back.= All the changes are written to the primary but are not sent to the cen= tral? Although these tables are in a replication. Is this normal ? Can anybody help me here ?? Thx in advance !! </tt> </body></html>= --1__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C-- --0__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=07BBE4F3DFF56B5C8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=07BBE4F3DFF56B5C8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=07BBE4F3DFF56B5C8f9e8a93df938690918c07BBE4F3DFF56B5C Content-type: image/gif; name="pic16417.gif" Content-Disposition: inline; filename="pic16417.gif" Content-ID: <30__=07BBE4F3DFF56B5C8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWs

informix enterprise replication

Glossary

Your privacy choices