This discussion is archived
1 Reply Latest reply: Jan 24, 2013 11:46 PM by 987086 RSS

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

user12103686 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points