1 Reply Latest reply: Jan 25, 2013 1:46 AM by 987086 RSS

    How a real-time network monitoring in replication with route clause

    user12103686
      I have some question.

      I am testing 2-Node Replication(with route clause).

      ########################

      create table SCOTT.TB_TEST1 (
      C1 TT_INTEGER NOT NULL,
      C2 CHAR(10 BYTE),
      C3 TT_INTEGER,
      C4 CHAR(10 BYTE),
      C5 CHAR(10 BYTE),
      C6 CHAR(10 BYTE),
      C7 CHAR(10 BYTE),
      C8 CHAR(10 BYTE),
      C9 TT_INTEGER,
      C10 DATE,
      primary key (C1));

      create replication SCOTT.REP1
      element E1 datastore
      master TEST on "TT_REP1"
      subscriber TEST on "TT_REP2"
      element E2 datastore
      master TEST on "TT_REP2"
      subscriber TEST on "TT_REP1"
      store TEST on "TT_REP1"
      timeout 30
      store TEST on "TT_REP2"
      timeout 30
      route master TEST on TT_REP1 subscriber TEST on TT_REP2
      masterip "10.10.10.27" priority 1
      masterip "10.10.100.27" priority 2
      subscriberip "10.10.10.28" priority 1
      subscriberip "10.10.100.28" priority 2
      route master TEST on TT_REP2 subscriber TEST on TT_REP1
      masterip "10.10.10.28" priority 1
      masterip "10.10.100.28" priority 2
      subscriberip "10.10.10.27" priority 1
      subscriberip "10.10.100.27" priority 2
      ;
      ########################

      Possible to know(in timesten query, built-in procedure, utility, etc) any network interface(real-time) with Replication ?

      Thank you very much.

      GooGyum