Oninit cdi / Archive
Talk to an expert →

cdr sync question

Posted in 2014

Topics: High Availability & Replication, Platform-Specific Issues

Andrew Grantham — — source: IIUG Forums & Mailing Lists

All, Informix 11.70.FC2 on Solaris 10. I have an ER environment with 10 source instances replicating to 1 destination instance. The destination instance has 2 databases. One for data from UTF8 databases and the other for the rest. I have a particular table that has the same number of rows but the contents of the data on the destination is different from the source for some rows. So I would like to remedy these differences. I have been reading the cdr sync command and cannot identify if it will fix column differences. So I will ask my learned colleagues if they can enlighten me? Or if you know of other commands then I am all ears. I realise I can alway copy the data from source to the destination which is no problem but I was hoping for a more ER based solution. I do not have the ATS or RIS files so I cannot use that option. Thanks Andy Grantham.

↪ replying to Andrew Grantham
Nagaraju Inturi — — source: IIUG Forums & Mailing Lists

Hi Andy, You can use 'cdr check replicate' command with --repair option to repair missing/mismatched rows. Thanks & Regards, Nagaraju From: "Andrew Grantham" <agrantha@hotmail.com> To: ids@iiug.org, Date: 01/22/2014 06:08 AM Subject: cdr sync question [32287] Sent by: ids-bounces@iiug.org All, Informix 11.70.FC2 on Solaris 10. I have an ER environment with 10 source instances replicating to 1 destination instance. The destination instance has 2 databases. One for data from UTF8 databases and the other for the rest. I have a particular table that has the same number of rows but the contents of the data on the destination is different from the source for some rows. So I would like to remedy these differences. I have been reading the cdr sync command and cannot identify if it will fix column differences. So I will ask my learned colleagues if they can enlighten me? Or if you know of other commands then I am all ears. I realise I can alway copy the data from source to the destination which is no problem but I was hoping for a more ER based solution. I do not have the ATS or RIS files so I cannot use that option. Thanks Andy Grantham. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary