Integrating a 14.10FC2 Server into a 12.10 based Enterprise Replication Network

Hi all, I am at the moment extending a production environment that include ER servers, where the existing servers run on 12.10 FC12. I am adding a new server running 14.10 FC2. Having done some tests yesterday on a lab environment, I ran into weird errors, plus I quickly read on the documentation site, upgrade section, that upgrading ER had some requirements to be executed. The question is: can I integrate my new 14.10 participant without having to perform specific tasks, considering that ER is supposed to work seamlessly in a network that includes servers running from 11.70 to current version ? thanks for any light ? ------------------------------ [eric] [Verceletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] ------------------------------ #Informix

Sure you can – and you even could use some 14.10 features then, in that ER domain, as long as executed from 14.10 environment and not restricted by lower versions on other nodes. So those weird errors occurred when upgrading some of your test servers – yet no upgrading involved in your real world scenario? HTH, Andreas ::DISCLAIMER:: The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.

Define weird errors :-) I have brought 14.10 into 11.7 envs without any issues BUT I was using the 14.10 cdr binary on ALL servers to get around a bug. This was with the blessing of HCL Cheers Paul > Hi all, > > I am at the moment extending a production environment that include ER > servers, where the existing servers run on 12.10 FC12. I am adding a new > server running 14.10 FC2. > > Having done some tests yesterday on a lab environment, I ran into weird > errors, plus I quickly read on the documentation site, upgrade section, > that upgrading ER had some requirements to be executed. > > The question is: can I integrate my new 14.10 participant without having > to perform specific tasks, considering that ER is supposed to work > seamlessly in a network that includes servers running from 11.70 to > current version ? > thanks for any light ? > > > > > > > ------------------------------ > [eric] [Verceletto] [] > [Founder] > [kandooerp.org] > [Pont l'Abb??] [France] > [+33 626 52 50 68] > ------------------------------ > > > Reply to Sender : > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&SenderKey=3f135a6d-8b93-447d-a75b-f8d9649841d6&MID=39177&MDATE=756%253e467458&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved > > Reply to Discussion : > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&MID=39177&MDATE=756%253e467458&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved > > > > You are subscribed to "Informix" as paul@oninit.com . To change your > subscriptions, go to > http://community.ibm.com/community/user/preferences?section=Subscriptions&MDATE=756%253e467458&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved. > To unsubscribe from this community discussion, go to > http://community.ibm.com/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved&GroupKey=60eb97a2-57c0-4130-9b6d-57174f97d5a8. -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit? is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

Hi again, sorry I was on other tasks in-between. So as per building an ER with 12.10 and 14.10, it finally worked great on the production environment, and apparently much faster that 12.10 =<> 12.10. (We integrated a new HDR pair of servers in 14.10, while the other servers are still on 12.10). So the product specs (any version above 11.70) are OK Now, back to the initial issue of the 'weird' errors, or should I call them 'speechless' errors. This time this is between 14.10 FC1 and 14.10 FC2, where I am not supposed to have issues anyway. cdr define server works ok on both ways. The problem comes with the cdr define repl command, which works fine in the other environment and not in this one. When I run: cdr define replicate --master source_grp --immediate --autocreate --conflict=ignore --scope=tran --ats replicate_name \\ "P src_db@src_grp:informix.src_table" "select * from src_table" \\ "R target_db@target_grp:informix.target_table" "select * from target_table" here is the stderr output: Verification of src_db@src_grp:informix.src_table started Verification of src_db@src_grp:informix.src_table is successful Verification of target_db@target_grp:informix.target_table started Verification of target_db@target_grp:informix.target_table failed Master Replicate Verification Total errors:1 command failed -- undefined replicate (31) the last verif fails although the table is created on the target side, but no clue on what failed. The communication seems to be ok else I would not have my table created on the target side. I looked in the syscdr:cdrerrors table and nothing about this operation. My problem is that I don't know WHAT failed in the last verification phase during the cdr define statement. Is there a log file or something that could lead me somewhere? By the way, the online.log file says nothing about this operation on both sides @Paul: is the solution you suggest consist in copying the most recent $INFORMIXDIR/bin/cdr binary to the 'older' servers and only this ? Thanks Eric ------------------------------ [eric] [Verceletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] ------------------------------

Hi Eric, can you compare or post src_table's and target_table's schemas, please? In general, the --autocreate is a nice, yet fairly restricted feature, e.g. it would not copy storage options, constraints or extra indices - so use with care, and rather create target tables by other means if you need more complexity. BR, Andreas ------------------------------ Andreas Legner ------------------------------

Yep - we just copied the $INFORMIDIR/bin/cdr from 14 to all the 11.7 machines Prior to running cdr command try Export MyTrace=1 It should dump all the SQL that cdr is using to the screen Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC

Great! I'll do that Cheers too thanks Paul! ------------------------------ [eric] [Verceletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] ------------------------------