IDS Forum

Re: ER between different platforms

Posted By: Marc Patino
Date: Thursday, 12 March 2009, at 11:14 a.m.

In Response To: Re: ER between different platforms (Madison Pruet)

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

Messages In This Thread

• ER between different platforms
  Marc Patino -- Thursday, 12 March 2009, at 9:06 a.m.
  • Re: ER between different platforms
    Madison Pruet -- Thursday, 12 March 2009, at 9:41 a.m.
    • Re: ER between different platforms
      Marc Patino -- Thursday, 12 March 2009, at 9:53 a.m.
      • Re: ER between different platforms
        Madison Pruet -- Thursday, 12 March 2009, at 10:07 a.m.
        • Re: ER between different platforms
          Marc Patino -- Thursday, 12 March 2009, at 11:14 a.m.
          • Re: ER between different platforms
            Marc Patino -- Wednesday, 18 March 2009, at 6:01 a.m.
            • RE: ER between different platforms
              Walter Milan -- Wednesday, 18 March 2009, at 12:44 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.