IDS Forum

RE: Table Replication

Posted By: Alexandre Marini
Date: Monday, 1 April 2013, at 6:40 a.m.

In Response To: Re: RE: Table Replication (MOHD FADZIL JUSOH)

Yes, indeed the only requirement for using ER replication, is that you can only do it in different database instances.
You should proceed in the same way as if your 2 instances are in separated machines.

Start creating a connection group for your instances, in your sqlhosts file (supposing you have only one file, for both instances):

grp_er1 group - - i=1
dev1_tcp onsoctcp masid [port_or_servicename] g=grp_er1
grp_er2 group - - i=2
dev2_tcp onsoctcp masid [port_or_servicename2] g=grp_er2

That should enable you to connect from one instance to another, through dbaccess -> connection -> connect menu.

From that on, you should proceed to the regular kind of ER setup you want to, as follows:
1) cdr define server ....... (in both instances)
2) a) cdr define replicate ..... (or)

b) cdr define template .....
3) from 2)a) setup: cdr start replicate .....

from 2)b) setup: cdr realize template ..... (in both ER nodes)

4) you must do an initial sync
(replicate sync, or template sync, depending on your previous choice of setup).

This is a basic cook receipt, but there are much more things you could enable to get thins easier to administer, and monitor... begin in this path, and if you have further questions, just let us know.

Regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70

IBM Information Management Informix Technical Professional

IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant

> To: ids@iiug.org
> From: fadzil@isianpadu.com
> Subject: Re: RE: Table Replication [29940]
> Date: Mon, 1 Apr 2013 05:18:14 -0400
>
> hi,
>
> thank for your advice.
> most sample replication i find, the replication between 2 server.
>
> what i need to do is replicate table between 2 intance on same server, dev1
> and dev2.
>
> host: masid
>
> 1. informixserver= dev1_tcp
>
> onconfig = onconfig.dev1
>
> database = demo1
>
> table = stores ( table need to duplicate)
>
> 2. informixserver= dev2_tcp
>
> onconfig = onconfig.dev2
>
> database = demo2
>
> table = stores ( table need to duplicate)
>
> Can informix have features to do replication like this? if can, please give me
> step by step how to do it, or sample
>
> please advice, tq
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• Table Replication
  MOHD FADZIL JUSOH -- Saturday, 30 March 2013, at 8:57 a.m.
  • RE: Table Replication
    Alexandre Marini -- Saturday, 30 March 2013, at 9:32 a.m.
    • Re: RE: Table Replication
      MOHD FADZIL JUSOH -- Monday, 1 April 2013, at 5:18 a.m.
      • RE: Table Replication
        Alexandre Marini -- Monday, 1 April 2013, at 6:40 a.m.
        • Re: RE: Table Replication
          MOHD FADZIL JUSOH -- Tuesday, 2 April 2013, at 9:18 p.m.
          • Re: Table Replication
            Madison Pruet -- Tuesday, 2 April 2013, at 10:41 p.m.
            • Re: Table Replication
              MOHD FADZIL JUSOH -- Wednesday, 3 April 2013, at 8:54 a.m.
          • RE: Table Replication
            Alexandre Marini -- Wednesday, 3 April 2013, at 6:55 a.m.
            • Re: RE: Table Replication
              MOHD FADZIL JUSOH -- Wednesday, 3 April 2013, at 9:04 p.m.
              • Re: RE: Table Replication
                Art Kagel -- Wednesday, 3 April 2013, at 9:10 p.m.
                • Re: RE: Table Replication
                  MOHD FADZIL JUSOH -- Thursday, 4 April 2013, at 8:49 p.m.
  • Re: Table Replication
    John Miller iii -- Saturday, 30 March 2013, at 11:03 a.m.
  • Re: Table Replication
    Madison Pruet -- Saturday, 30 March 2013, at 8:50 p.m.
    • Re: Table Replication
      MOHD FADZIL JUSOH -- Monday, 1 April 2013, at 3:21 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.