ER between different platforms

Hi, I am testing IDS ER replication between different servers (linux, aix and solaris) without success. Nowadays all our production servers are GNU/Linux x86 and IDS ER replication works well. We are planning to migrate our OLTP central server to a new Sun or IBM server. So I am testing IDS ER between Linux - AIX Linux - Solaris without success. For example when I want to add a new Solaris IDS to ER I got the following error: informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C ignore -S row -A tablatest \\\\ > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest" \\\\ > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest" \\\\ > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest" Verification of fedefarm@g_suxdes1:informix.tablatest started Verification of fedefarm@g_suxdes1:informix.tablatest is successful Verification of fedefarm@g_suxdes2:informix.tablatest started Verification of fedefarm@g_suxdes2:informix.tablatest is successful Verification of fedefarm@g_solaris:informix.tablatest started connect to fedefarm@g_solaris failed This feature of Enterprise Replication is not yet supported. (101) command failed -- unable to connect to server specified (5) IDS conectivity is working between servers, because with dbaccess I can connect to every server without problems I have the following questions: - First of all: ER works between different platforms? - ER works between diferent releases of IDS (for example 10 and 11.5) and also with diferent platfforms ? Any advices, pointers, sugestions will be welcome. Thanks, Marc --000e0cd28e9c1341860464eba818

What version is g_solaris? ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "Marc Patino" = <marcpatino@gmail = .com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect ER between different platforms = 03/12/2009 08:06 [15106] = AM = = = Please respond to = ids@iiug.org = = = Hi, I am testing IDS ER replication between different servers (linux, aix a= nd solaris) without success. Nowadays all our production servers are GNU/L= inux x86 and IDS ER replication works well. We are planning to migrate our O= LTP central server to a new Sun or IBM server. So I am testing IDS ER betwe= en Linux - AIX Linux - Solaris without success. For example when I want to add a new Solaris IDS to ER= I got the following error: informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C ign= ore -S row -A tablatest \\\\ > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest" \\\\= > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest" \\\\= > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest" Verification of fedefarm@g_suxdes1:informix.tablatest started Verification of fedefarm@g_suxdes1:informix.tablatest is successful Verification of fedefarm@g_suxdes2:informix.tablatest started Verification of fedefarm@g_suxdes2:informix.tablatest is successful Verification of fedefarm@g_solaris:informix.tablatest started connect to fedefarm@g_solaris failed This feature of Enterprise Replication is not yet supported. (101) command failed -- unable to connect to server specified (5) IDS conectivity is working between servers, because with dbaccess I can= connect to every server without problems I have the following questions: - First of all: ER works between different platforms? - ER works between diferent releases of IDS (for example 10 and 11.5) a= nd also with diferent platfforms ? Any advices, pointers, sugestions will be welcome. Thanks, Marc --000e0cd28e9c1341860464eba818 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Hi, g_solaris is 11.50.FC1 ( Solaris 10 zone) g_suxdes is 10FC9 ( Linux ) also I have tried between 11.5FC1 (Aix) against 11.5FC2 (Linux) in the second enviroment ER works, but commands like cdr sync replicate cdr check repl do not work. Thanks, Marc On Thu, Mar 12, 2009 at 2:41 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > What version is g_solaris? > > ------------------------------------- > Madison Pruet, STSM > IDS Replication Architect > > = > > "Marc Patino" = > > <marcpatino@gmail = > > ..com> = > To > > Sent by: ids@iiug.org = > > ids-bounces@iiug. = > cc > > org = > > Subj= > ect > > ER between different platforms = > > 03/12/2009 08:06 [15106] = > > AM = > > = > > = > > Please respond to = > > ids@iiug.org = > > = > > = > > Hi, > > I am testing IDS ER replication between different servers (linux, aix a= > nd > solaris) without success. Nowadays all our production servers are GNU/L= > inux > > x86 and IDS ER replication works well. We are planning to migrate our O= > LTP > central server to a new Sun or IBM server. So I am testing IDS ER betwe= > en > > Linux - AIX > Linux - Solaris > > without success. For example when I want to add a new Solaris IDS to ER= > I > got the following error: > > informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C ign= > ore > -S row -A tablatest \\\\ > > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest" \\\\= > > > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest" \\\\= > > > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest" > > Verification of fedefarm@g_suxdes1:informix.tablatest started > Verification of fedefarm@g_suxdes1:informix.tablatest is successful > Verification of fedefarm@g_suxdes2:informix.tablatest started > Verification of fedefarm@g_suxdes2:informix.tablatest is successful > Verification of fedefarm@g_solaris:informix.tablatest started > connect to fedefarm@g_solaris failed > This feature of Enterprise Replication is not yet supported. (101) > command failed -- unable to connect to server specified (5) > > IDS conectivity is working between servers, because with dbaccess I can= > > connect to every server without problems > > I have the following questions: > > - First of all: ER works between different platforms? > - ER works between diferent releases of IDS (for example 10 and 11.5) a= > nd > also with diferent platfforms ? > > Any advices, pointers, sugestions will be welcome. > > Thanks, > > Marc > > --000e0cd28e9c1341860464eba818 > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd2457a1257430464ec4ed0

You will need to run sync and check as user informix. It has to be abl= e to examine and compare tables on all of the nodes. You will need to use the cdr utility on the most recent server. I'm guessing that you used the cdr utility on the 10 server to try to execu= te the define replicate. Since you are defining a mastered replicate, the= cdr utility will attempt to connect to all of the servers to verify that th= e tables match. If you use the cdr utility from IDS10, then you will not= be able to process on the IDS 11 server. ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "Marc Patino" = <marcpatino@gmail = .com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Re: ER between different platfor= ms 03/12/2009 08:53 [15108] = AM = = = Please respond to = ids@iiug.org = = = Hi, g_solaris is 11.50.FC1 ( Solaris 10 zone) g_suxdes is 10FC9 ( Linux ) also I have tried between 11.5FC1 (Aix) against 11.5FC2 (Linux) in the second enviroment ER works, but commands like cdr sync replicate cdr check repl do not work. Thanks, Marc On Thu, Mar 12, 2009 at 2:41 PM, Madison Pruet <mpruet@us.ibm.com> wrot= e: > What version is g_solaris? > > ------------------------------------- > Madison Pruet, STSM > IDS Replication Architect > > =3D > > "Marc Patino" =3D > > <marcpatino@gmail =3D > > ..com> =3D > To > > Sent by: ids@iiug.org =3D > > ids-bounces@iiug. =3D > cc > > org =3D > > Subj=3D > ect > > ER between different platforms =3D > > 03/12/2009 08:06 [15106] =3D > > AM =3D > > =3D > > =3D > > Please respond to =3D > > ids@iiug.org =3D > > =3D > > =3D > > Hi, > > I am testing IDS ER replication between different servers (linux, aix= a=3D > nd > solaris) without success. Nowadays all our production servers are GNU= /L=3D > inux > > x86 and IDS ER replication works well. We are planning to migrate our= O=3D > LTP > central server to a new Sun or IBM server. So I am testing IDS ER bet= we=3D > en > > Linux - AIX > Linux - Solaris > > without success. For example when I want to add a new Solaris IDS to = ER=3D > I > got the following error: > > informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C i= gn=3D > ore > -S row -A tablatest \\\\ > > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest"= \\\\=3D > > > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest"= \\\\=3D > > > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest"= > > Verification of fedefarm@g_suxdes1:informix.tablatest started > Verification of fedefarm@g_suxdes1:informix.tablatest is successful > Verification of fedefarm@g_suxdes2:informix.tablatest started > Verification of fedefarm@g_suxdes2:informix.tablatest is successful > Verification of fedefarm@g_solaris:informix.tablatest started > connect to fedefarm@g_solaris failed > This feature of Enterprise Replication is not yet supported. (101) > command failed -- unable to connect to server specified (5) > > IDS conectivity is working between servers, because with dbaccess I c= an=3D > > connect to every server without problems > > I have the following questions: > > - First of all: ER works between different platforms? > - ER works between diferent releases of IDS (for example 10 and 11.5)= a=3D > nd > also with diferent platfforms ? > > Any advices, pointers, sugestions will be welcome. > > Thanks, > > Marc > > --000e0cd28e9c1341860464eba818 > > *********************************************************************= **=3D > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > =3D > > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd2457a1257430464ec4ed0 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Hi Madison, On Thu, Mar 12, 2009 at 3:07 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > You will need to run sync and check as user informix. It has to be abl= > e to > examine and compare tables on all of the nodes. yes, I always use informix user to do these commands > > You will need to use the cdr utility on the most recent server. I'm > guessing that you used the cdr utility on the 10 server to try to execu= > te > the define replicate. Since you are defining a mastered replicate, the= > cdr > utility will attempt to connect to all of the servers to verify that th= > e > tables match. If you use the cdr utility from IDS10, then you will not= > be > able to process on the IDS 11 server. Yes! you are right. I used cdr utility from IDS 10 . Tomorrow I will test in IDS 11.5 Many thanks for your answers, Marc > > > ------------------------------------- > Madison Pruet, STSM > IDS Replication Architect > > = > > "Marc Patino" = > > <marcpatino@gmail = > > ..com> = > To > > Sent by: ids@iiug.org = > > ids-bounces@iiug. = > cc > > org = > > Subj= > ect > > Re: ER between different platfor= > ms > > 03/12/2009 08:53 [15108] = > > AM = > > = > > = > > Please respond to = > > ids@iiug.org = > > = > > = > > Hi, > > g_solaris is 11.50.FC1 ( Solaris 10 zone) > g_suxdes is 10FC9 ( Linux ) > > also I have tried between > > 11.5FC1 (Aix) against 11.5FC2 (Linux) > > in the second enviroment ER works, but commands like > > cdr sync replicate > > cdr check repl > > do not work. > > Thanks, > > Marc > > On Thu, Mar 12, 2009 at 2:41 PM, Madison Pruet <mpruet@us.ibm.com> wrot= > e: > > > What version is g_solaris? > > > > ------------------------------------- > > Madison Pruet, STSM > > IDS Replication Architect > > > > =3D > > > > "Marc Patino" =3D > > > > <marcpatino@gmail =3D > > > > ..com> =3D > > To > > > > Sent by: ids@iiug.org =3D > > > > ids-bounces@iiug. =3D > > cc > > > > org =3D > > > > Subj=3D > > ect > > > > ER between different platforms =3D > > > > 03/12/2009 08:06 [15106] =3D > > > > AM =3D > > > > =3D > > > > =3D > > > > Please respond to =3D > > > > ids@iiug.org =3D > > > > =3D > > > > =3D > > > > Hi, > > > > I am testing IDS ER replication between different servers (linux, aix= > a=3D > > nd > > solaris) without success. Nowadays all our production servers are GNU= > /L=3D > > inux > > > > x86 and IDS ER replication works well. We are planning to migrate our= > O=3D > > LTP > > central server to a new Sun or IBM server. So I am testing IDS ER bet= > we=3D > > en > > > > Linux - AIX > > Linux - Solaris > > > > without success. For example when I want to add a new Solaris IDS to = > ER=3D > > I > > got the following error: > > > > informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C i= > gn=3D > > ore > > -S row -A tablatest \\\\ > > > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest"= > \\\\=3D > > > > > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest"= > \\\\=3D > > > > > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest"= > > > > > Verification of fedefarm@g_suxdes1:informix.tablatest started > > Verification of fedefarm@g_suxdes1:informix.tablatest is successful > > Verification of fedefarm@g_suxdes2:informix.tablatest started > > Verification of fedefarm@g_suxdes2:informix.tablatest is successful > > Verification of fedefarm@g_solaris:informix.tablatest started > > connect to fedefarm@g_solaris failed > > This feature of Enterprise Replication is not yet supported. (101) > > command failed -- unable to connect to server specified (5) > > > > IDS conectivity is working between servers, because with dbaccess I c= > an=3D > > > > connect to every server without problems > > > > I have the following questions: > > > > - First of all: ER works between different platforms? > > - ER works between diferent releases of IDS (for example 10 and 11.5)= > a=3D > > nd > > also with diferent platfforms ? > > > > Any advices, pointers, sugestions will be welcome. > > > > Thanks, > > > > Marc > > > > --000e0cd28e9c1341860464eba818 > > > > *********************************************************************= > **=3D > > ******** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > =3D > > > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --000e0cd2457a1257430464ec4ed0 > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd25bd01795d30464ed6e89

Hi, after following Madison's advices the ER replication works ok between GNU/Linux and Solaris, the only exception is the command cdr check repl on Solaris server online.log shows the following error: 10:25:00 Loading Module <$INFORMIXDIR/extend/checksum/idschecksum.so> 10:25:00 (2): The C Language Module <$INFORMIXDIR/extend/checksum/idschecksum.so> can't load reason: Cannot access library file 10:25:00 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/checksum/idschecksum.so> I have some related issues with idschecksum after migration from 10DC8 to 10FC9 and I solved them executing the script $INFORMIXDIR/etc/idschecksum.sql on all databases that replicates via ER. But on solaris box (IDS 11.5) this sql script don't exist, so I copied it from other machine but know the library idschecksum.so is not present. Any advices? Many thanks, Marc On Thu, Mar 12, 2009 at 4:14 PM, Marc Patino <marcpatino@gmail.com> wrote: > Hi Madison, > > On Thu, Mar 12, 2009 at 3:07 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > > > You will need to run sync and check as user informix. It has to be abl= > > e to > > examine and compare tables on all of the nodes. > > yes, I always use informix user to do these commands > > > > > You will need to use the cdr utility on the most recent server. I'm > > guessing that you used the cdr utility on the 10 server to try to execu= > > te > > the define replicate. Since you are defining a mastered replicate, the= > > cdr > > utility will attempt to connect to all of the servers to verify that th= > > e > > tables match. If you use the cdr utility from IDS10, then you will not= > > be > > able to process on the IDS 11 server. > > Yes! you are right. I used cdr utility from IDS 10 . Tomorrow I will test > in > IDS 11.5 > > Many thanks for your answers, > > Marc > > > > > > > ------------------------------------- > > Madison Pruet, STSM > > IDS Replication Architect > > > > = > > > > "Marc Patino" = > > > > <marcpatino@gmail = > > > > ..com> = > > To > > > > Sent by: ids@iiug.org = > > > > ids-bounces@iiug. = > > cc > > > > org = > > > > Subj= > > ect > > > > Re: ER between different platfor= > > ms > > > > 03/12/2009 08:53 [15108] = > > > > AM = > > > > = > > > > = > > > > Please respond to = > > > > ids@iiug.org = > > > > = > > > > = > > > > Hi, > > > > g_solaris is 11.50.FC1 ( Solaris 10 zone) > > g_suxdes is 10FC9 ( Linux ) > > > > also I have tried between > > > > 11.5FC1 (Aix) against 11.5FC2 (Linux) > > > > in the second enviroment ER works, but commands like > > > > cdr sync replicate > > > > cdr check repl > > > > do not work. > > > > Thanks, > > > > Marc > > > > On Thu, Mar 12, 2009 at 2:41 PM, Madison Pruet <mpruet@us.ibm.com> wrot= > > e: > > > > > What version is g_solaris? > > > > > > ------------------------------------- > > > Madison Pruet, STSM > > > IDS Replication Architect > > > > > > =3D > > > > > > "Marc Patino" =3D > > > > > > <marcpatino@gmail =3D > > > > > > ..com> =3D > > > To > > > > > > Sent by: ids@iiug.org =3D > > > > > > ids-bounces@iiug. =3D > > > cc > > > > > > org =3D > > > > > > Subj=3D > > > ect > > > > > > ER between different platforms =3D > > > > > > 03/12/2009 08:06 [15106] =3D > > > > > > AM =3D > > > > > > =3D > > > > > > =3D > > > > > > Please respond to =3D > > > > > > ids@iiug.org =3D > > > > > > =3D > > > > > > =3D > > > > > > Hi, > > > > > > I am testing IDS ER replication between different servers (linux, aix= > > a=3D > > > nd > > > solaris) without success. Nowadays all our production servers are GNU= > > /L=3D > > > inux > > > > > > x86 and IDS ER replication works well. We are planning to migrate our= > > O=3D > > > LTP > > > central server to a new Sun or IBM server. So I am testing IDS ER bet= > > we=3D > > > en > > > > > > Linux - AIX > > > Linux - Solaris > > > > > > without success. For example when I want to add a new Solaris IDS to = > > ER=3D > > > I > > > got the following error: > > > > > > informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C i= > > gn=3D > > > ore > > > -S row -A tablatest \\\\ > > > > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest"= > > \\\\=3D > > > > > > > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest"= > > \\\\=3D > > > > > > > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest"= > > > > > > > > Verification of fedefarm@g_suxdes1:informix.tablatest started > > > Verification of fedefarm@g_suxdes1:informix.tablatest is successful > > > Verification of fedefarm@g_suxdes2:informix.tablatest started > > > Verification of fedefarm@g_suxdes2:informix.tablatest is successful > > > Verification of fedefarm@g_solaris:informix.tablatest started > > > connect to fedefarm@g_solaris failed > > > This feature of Enterprise Replication is not yet supported. (101) > > > command failed -- unable to connect to server specified (5) > > > > > > IDS conectivity is working between servers, because with dbaccess I c= > > an=3D > > > > > > connect to every server without problems > > > > > > I have the following questions: > > > > > > - First of all: ER works between different platforms? > > > - ER works between diferent releases of IDS (for example 10 and 11.5)= > > a=3D > > > nd > > > also with diferent platfforms ? > > > > > > Any advices, pointers, sugestions will be welcome. > > > > > > Thanks, > > > > > > Marc > > > > > > --000e0cd28e9c1341860464eba818 > > > > > > *********************************************************************= > > **=3D > > > ******** > > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > =3D > > > > > > > > > > > > > > ***********************************************************************= > > ******** > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --000e0cd2457a1257430464ec4ed0 > > > > ***********************************************************************= > > ******** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > = > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --000e0cd25bd01795d30464ed6e89 > > > > ******************************************************************************* > Forum Note: Use "Reply@@DQ

Did you try to run de cdr check repl from 11.50? it looks like your log file is a pre-11.50. That could be your problem. Cheetah has a built-in checksum, you don't need to set up anything. Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marc Patino Sent: Wednesday, March 18, 2009 5:02 AM To: ids@iiug.org Subject: Re: ER between different platforms [15210] Hi, after following Madison's advices the ER replication works ok between GNU/Linux and Solaris, the only exception is the command cdr check repl on Solaris server online.log shows the following error: 10:25:00 Loading Module <$INFORMIXDIR/extend/checksum/idschecksum.so> 10:25:00 (2): The C Language Module <$INFORMIXDIR/extend/checksum/idschecksum.so> can't load reason: Cannot access library file 10:25:00 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/checksum/idschecksum.so> I have some related issues with idschecksum after migration from 10DC8 to 10FC9 and I solved them executing the script $INFORMIXDIR/etc/idschecksum.sql on all databases that replicates via ER. But on solaris box (IDS 11.5) this sql script don't exist, so I copied it from other machine but know the library idschecksum.so is not present. Any advices? Many thanks, Marc On Thu, Mar 12, 2009 at 4:14 PM, Marc Patino <marcpatino@gmail.com> wrote: > Hi Madison, > > On Thu, Mar 12, 2009 at 3:07 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > > > You will need to run sync and check as user informix. It has to be abl= > > e to > > examine and compare tables on all of the nodes. > > yes, I always use informix user to do these commands > > > > > You will need to use the cdr utility on the most recent server. I'm > > guessing that you used the cdr utility on the 10 server to try to execu= > > te > > the define replicate. Since you are defining a mastered replicate, the= > > cdr > > utility will attempt to connect to all of the servers to verify that th= > > e > > tables match. If you use the cdr utility from IDS10, then you will not= > > be > > able to process on the IDS 11 server. > > Yes! you are right. I used cdr utility from IDS 10 . Tomorrow I will test > in > IDS 11.5 > > Many thanks for your answers, > > Marc > > > > > > > ------------------------------------- > > Madison Pruet, STSM > > IDS Replication Architect > > > > = > > > > "Marc Patino" = > > > > <marcpatino@gmail = > > > > ..com> = > > To > > > > Sent by: ids@iiug.org = > > > > ids-bounces@iiug. = > > cc > > > > org = > > > > Subj= > > ect > > > > Re: ER between different platfor= > > ms > > > > 03/12/2009 08:53 [15108] = > > > > AM = > > > > = > > > > = > > > > Please respond to = > > > > ids@iiug.org = > > > > = > > > > = > > > > Hi, > > > > g_solaris is 11.50.FC1 ( Solaris 10 zone) > > g_suxdes is 10FC9 ( Linux ) > > > > also I have tried between > > > > 11.5FC1 (Aix) against 11.5FC2 (Linux) > > > > in the second enviroment ER works, but commands like > > > > cdr sync replicate > > > > cdr check repl > > > > do not work. > > > > Thanks, > > > > Marc > > > > On Thu, Mar 12, 2009 at 2:41 PM, Madison Pruet <mpruet@us.ibm.com> wrot= > > e: > > > > > What version is g_solaris? > > > > > > ------------------------------------- > > > Madison Pruet, STSM > > > IDS Replication Architect > > > > > > =3D > > > > > > "Marc Patino" =3D > > > > > > <marcpatino@gmail =3D > > > > > > ..com> =3D > > > To > > > > > > Sent by: ids@iiug.org =3D > > > > > > ids-bounces@iiug. =3D > > > cc > > > > > > org =3D > > > > > > Subj=3D > > > ect > > > > > > ER between different platforms =3D > > > > > > 03/12/2009 08:06 [15106] =3D > > > > > > AM =3D > > > > > > =3D > > > > > > =3D > > > > > > Please respond to =3D > > > > > > ids@iiug.org =3D > > > > > > =3D > > > > > > =3D > > > > > > Hi, > > > > > > I am testing IDS ER replication between different servers (linux, aix= > > a=3D > > > nd > > > solaris) without success. Nowadays all our production servers are GNU= > > /L=3D > > > inux > > > > > > x86 and IDS ER replication works well. We are planning to migrate our= > > O=3D > > > LTP > > > central server to a new Sun or IBM server. So I am testing IDS ER bet= > > we=3D > > > en > > > > > > Linux - AIX > > > Linux - Solaris > > > > > > without success. For example when I want to add a new Solaris IDS to = > > ER=3D > > > I > > > got the following error: > > > > > > informix@suxdes1:~$ cdr define repl -c g_suxdes1 -u -M g_suxdes1 -C i= > > gn=3D > > > ore > > > -S row -A tablatest \\\\ > > > > "P fedefarm@g_suxdes1:informix.tablatest" "select * from tablatest"= > > \\\\=3D > > > > > > > "R fedefarm@g_suxdes2:informix.tablatest" "select * from tablatest"= > > \\\\=3D > > > > > > > "R fedefarm@g_solaris:informix.tablatest" "select * from tablatest"= > > > > > > > > Verification of fedefarm@g_suxdes1:informix.tablatest started > > > Verification of fedefarm@g_suxdes1:informix.tablatest is successful > > > Verification of fedefarm@g_suxdes2:informix.tablatest started > > > Verification of fedefarm@g_suxdes2:informix.tablatest is successful > > > Verification of fedefarm@g_solaris:informix.tablatest started > > > connect to fedefarm@g_solaris failed > > > This feature of Enterprise Replication is not yet supported. (101) > > > command failed -- unable to connect to server specified (5) > > > > > > IDS conectivity is working between servers, because with dbaccess I c= > > an=3D > > > > > > connect to every server without problems > > > > > > I have the following questions: > > > > > > - First of all: ER works between different platforms? > > > - ER works between diferent releases of IDS (for example 10 and 11.5)= > > a=3D > > > nd > > > also with diferent platfforms ? > > > > > > Any advices, pointers, sugestions will be welcome. > > > > > > Thanks, > > > > > > Marc > > > > > > --000e0cd28e9c1341860464eba818 > > > > > > *********************************************************************= > > **=3D > > > ******** > > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > =3D > > > > > > > > > > > > > > ***********************************************************************= > > ******** > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --000e0cd2457a1257430464ec4ed0 > > > > ***********************************************************************= > > ******** > > > > Forum Note: Use "Reply" to