Enterprise Replication question

Posted in 2007

Jarrod Teale — Mon, 30 Jul 2007 15:27:13 +1200 — source: Usenet: comp.databases.informix

Hi, Running 10.00.UC3 -> 10.00.UC3 replication, both on RedHat EL 4 I set up a one-way replicate to transfer data and it works beautifully (Go Informix) but I forgot to set the frequency option in the replicate. I've now set it to the right thing, using cdr modify replicate but it doesn't seem to have taken effect. (You can see the 10 minute frequency below) The records are still arriving at the central server at the end of each transaction, not caching for 10 minutes before being sent Any ideas? Jarrod Teale Fonterra New Zealand. [informix@sirrp71(10.71.64.130) ~]$ cdr list repl sirrp71_stan_tagsamples DEFINED REPLICATES ATTRIBUTES ------------------------------ REPLICATE: sirrp71_stan_tagsamples STATE: Active ON:sirrp71 CONFLICT: Ignore FREQUENCY: every 00:10 QUEUE SIZE: 0 PARTICIPANT: stan:sdev.tagsamples OPTIONS: transaction,fullrow [informix@sirrp71(10.71.64.130) ~]$ cdr list repl brief sirrp71_stan_tagsamples REPLICATE TABLE SELECT ------------------------------------------------------------------------ ---- sirrp71_stan_tagsamples stan@g_sirrp71:sdev.tagsamples <mailto:stan@g_sirrp71:sdev.tagsamples> SELECT * FROM tagsamples sirrp71_stan_tagsamples db@g_hades:owner.table <mailto:db@g_hades:owner.table> select * from table DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/

↪ replying to Jarrod Teale

Madison Pruet — Mon, 30 Jul 2007 04:08:28 GMT — source: Usenet: comp.databases.informix

Jarrod Teale wrote: > Hi, > Running 10.00.UC3 -> 10.00.UC3 replication, both on RedHat EL 4 > > I set up a one-way replicate to transfer data and it works beautifully > (Go Informix) > but I forgot to set the frequency option in the replicate. Please post the command you used to define the replicate and also the 'cdr modify repl' command that you issued. M.P. > > I've now set it to the right thing, using cdr modify replicate but it > doesn't seem to have taken effect. (You can see the 10 minute frequency > below) > > The records are still arriving at the central server at the end of each > transaction, not caching for 10 minutes before being sent > > Any ideas? > > Jarrod Teale > Fonterra New Zealand. > > > > [informix@sirrp71(10.71.64.130) ~]$ cdr list repl sirrp71_stan_tagsamples > > DEFINED REPLICATES ATTRIBUTES > ------------------------------ > REPLICATE: sirrp71_stan_tagsamples > STATE: Active ON:sirrp71 > CONFLICT: Ignore > FREQUENCY: every 00:10 > QUEUE SIZE: 0 > PARTICIPANT: stan:sdev.tagsamples > OPTIONS: transaction,fullrow > > [informix@sirrp71(10.71.64.130) ~]$ cdr list repl brief > sirrp71_stan_tagsamples > > REPLICATE TABLE SELECT > ---------------------------------------------------------------------------- > sirrp71_stan_tagsamples stan@g_sirrp71:sdev.tagsamples > <mailto:stan@g_sirrp71:sdev.tagsamples> SELECT * FROM tagsamples > sirrp71_stan_tagsamples db@g_hades:owner.table > <mailto:db@g_hades:owner.table> select * from table > > DISCLAIMER: > This email contains confidential information and may be legally > privileged. If you are not the intended recipient or have received this > email in error, please notify the sender immediately and destroy this email. > You may not use, disclose or copy this email or its attachments in any way. > Any opinions expressed in this email are those of the author and are not > necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ >

↪ replying to Madison Pruet

Jarrod Teale — Mon, 30 Jul 2007 16:14:17 +1200 — source: Usenet: comp.databases.informix

Madison, I defined the replicate like this > cdr define repl -C ignore sirrp71_stan_tagsamples \\ > "R stan@g_hades:sdev.tagsamples_71" "SELECT * FROM tagsamples_71" \\ > "P stan@g_sirrp71:sdev.tagsamples" "SELECT * FROM tagsamples" Made this adjustment > cdr modify repl --ignoredel y sirrp71_stan_tagsamples Then made the time adjustment > cdr modify repl -e 10 sirrp71_stan_tagsamples I've also tried deleting the replicate and recreating with the -e flag in the define step but still see transactions rolling in every few seconds Thanks Jarrod -----Original Message----- From: Madison Pruet [mailto:mpruet1@verizon.net] Sent: Monday, 30 July 2007 4:09 p.m. To: Jarrod Teale Cc: informix-list@iiug.org Subject: Re: Enterprise Replication question Jarrod Teale wrote: > Hi, > Running 10.00.UC3 -> 10.00.UC3 replication, both on RedHat EL 4 > > I set up a one-way replicate to transfer data and it works beautifully > (Go Informix) but I forgot to set the frequency option in the > replicate. Please post the command you used to define the replicate and also the 'cdr modify repl' command that you issued. M.P. > > I've now set it to the right thing, using cdr modify replicate but it > doesn't seem to have taken effect. (You can see the 10 minute > frequency > below) > > The records are still arriving at the central server at the end of > each transaction, not caching for 10 minutes before being sent > > Any ideas? > > Jarrod Teale > Fonterra New Zealand. > > > > [informix@sirrp71(10.71.64.130) ~]$ cdr list repl > sirrp71_stan_tagsamples > > DEFINED REPLICATES ATTRIBUTES > ------------------------------ > REPLICATE: sirrp71_stan_tagsamples > STATE: Active ON:sirrp71 > CONFLICT: Ignore > FREQUENCY: every 00:10 > QUEUE SIZE: 0 > PARTICIPANT: stan:sdev.tagsamples > OPTIONS: transaction,fullrow > > [informix@sirrp71(10.71.64.130) ~]$ cdr list repl brief > sirrp71_stan_tagsamples > > REPLICATE TABLE SELECT > ---------------------------------------------------------------------- > ------ sirrp71_stan_tagsamples stan@g_sirrp71:sdev.tagsamples > <mailto:stan@g_sirrp71:sdev.tagsamples> SELECT * FROM tagsamples > sirrp71_stan_tagsamples db@g_hades:owner.table > <mailto:db@g_hades:owner.table> select * from table > > DISCLAIMER: > This email contains confidential information and may be legally > privileged. If you are not the intended recipient or have received > this email in error, please notify the sender immediately and destroy this email. > You may not use, disclose or copy this email or its attachments in any way. > Any opinions expressed in this email are those of the author and are > not necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ > DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/

Glossary

Enterprise Replication (ER/CDR)