I'm testing TT Replication now.
With 2 DS on one machine, the replication worked.
But when the datastores are on seperate machines, no data got replicated.
(I've added the ip addresses in hosts file and made sure the two machines can ping each other.)
I monitored the replication with ttRepAdmin -showstatus on both machines,
and found the following error:
Earlier errors (max 5):
TT16137 in transmitter.c (line 5097) at 11:29:04 on 07-05-2006
does anybody know why and how to solve the problem?
======================================
D:\Documents and Settings\Administrator>ttIsql
Copyright (c) 1996-2006, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.
Command> connect TT_tt60;
Connection successful: DSN=TT_tt60;UID=Administrator;DataStore=C:\TIMEST~1\TT_tt
(Default setting AutoCommit=1)
Command> CREATE TABLE accounts (custname VARCHAR(30) NOT NULL,
address VARCHAR(80),
curbalance DEC(15,2),
tstamp BINARY(8),
PRIMARY KEY (custname));
Command>
Command> CREATE REPLICATION r1
ELEMENT elem_accounts_1 TABLE accounts
MASTER Sample_tt60 ON leonfine
SUBSCRIBER TT_tt60 ON monkey
ELEMENT elem_accounts_2 TABLE accounts
MASTER TT_tt60 ON monkey
SUBSCRIBER Sample_tt60 ON leonfine;
Command>
Command> call ttRepStart();
Command> exit
Disconnecting...
Done.
C:\Documents and Settings\Administrator>ttRepAdmin -showstatus TT_tt60
Replication Agent Status as of: 2006-07-05 11:29:07
DSN : TT_tt60
Process ID : 2020 (Started)
Replication Agent Policy : manual
Host : MONKEY
RepListener Port : 1499 (AUTO)
Last write LSN : 0.384200
Last LSN forced to disk : 0.384200
Replication hold LSN : 0.375464
Replication Peers:
Name : SAMPLE_TT60
Host : LEONFINE
Port : 37452 (AUTO) (Connected)
Replication State : STARTED
Communication Protocol : 20
TRANSMITTER thread(s):
For : SAMPLE_TT60
Start/Restart count : 17
Send LSN : 0.375464
Transactions sent : 0
Total packets sent : 17
Tick packets sent : 0
MIN sent packet size : 124
MAX sent packet size : 124
AVG sent packet size : 124
Last packet sent at : 11:29:04
Total Packets received: 17
MIN rcvd packet size : 48
MAX rcvd packet size : 48
AVG rcvd packet size : 48
Last packet rcvd'd at : 11:29:04
Earlier errors (max 5):
TT16137 in transmitter.c (line 5097) at 11:29:04 on 07-05-2006