Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    21

    Unanswered: Define Replicate

    Hello,

    I want to start Informix Replication on one Server between two Databases. I have defined a DBSERVERALIASNAME=iibm02_alias and put the DBSERVERNAME=iibm02 and the DBSERVERALIASNAME in one group named "group_1" in the SQLHOSTS file.
    Now I want to define the Replicate but I can't take the same Groupname for Primary and Receive-only Server definition. This is the command I start to define the Replicate:

    cdr define replicate -I -S trans -C ignore -i repl_1
    "P source@group_1:informix.source_t" "select * from source_t"
    "R target@group_1:informix.target_t" "select * from target_t"

    Failure: command failed -- duplicate server or replicate (53)
    participant source@group_1:informix.source_t 'select * from source_t'


    Thanks for all help...

    Best Regards,
    Marcus

  2. #2
    Join Date
    Mar 2004
    Posts
    6
    Lo m8,

    you use a wrong syntax :

    Try this one:

    cdr define server

    cdr define replicate --conflict=ignore repl_1
    "P source@group_1:informix.source_t" "select * from source_t"
    "R target@group_1:informix.target_t" "select * from target_t"


    Quote Originally Posted by VitaminB
    Hello,

    I want to start Informix Replication on one Server between two Databases. I have defined a DBSERVERALIASNAME=iibm02_alias and put the DBSERVERNAME=iibm02 and the DBSERVERALIASNAME in one group named "group_1" in the SQLHOSTS file.
    Now I want to define the Replicate but I can't take the same Groupname for Primary and Receive-only Server definition. This is the command I start to define the Replicate:

    cdr define replicate -I -S trans -C ignore -i repl_1
    "P source@group_1:informix.source_t" "select * from source_t"
    "R target@group_1:informix.target_t" "select * from target_t"

    Failure: command failed -- duplicate server or replicate (53)
    participant source@group_1:informix.source_t 'select * from source_t'


    Thanks for all help...

    Best Regards,
    Marcus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •