Technical data

Replication does not work
Troubleshooting Replication 6-5
Replication policy : Manual
Cache agent policy : Manual
------------------------------------------------------------------------
End of report
Example 6–2 Replication agent is not running
> ttStatus
TimesTen status report as of Tue Oct 28 10:31:30 2006
Daemon pid 3396 port 15000 instance MYINSTANCE
TimesTen server pid 3436 started on port 15002
-----------------------------------------------------------------
Data store c:\temp\subscriberds
There are no connections to the data store
cache agent restart policy: manual
-----------------------------------------------------------------
Data store c:\temp\masterds
There are no connections to the data store
cache agent restart policy: manual
-----------------------------------------------------------------
End of report
Example 6–3 TimesTen daemon and replication agent are not running
> ttStatus
ttStatus: Could not connect to TimesTen daemon: Connection refused
Check that replication agents are communicating
Use ttRepAdmin -receiver -list to see that the replication agents are
communicating with each other. If the masterds data store is replicating to
subscriberds, the output should look similar to the following:
Example 6–4 Check that the replication agents are communicating
> ttRepAdmin -receiver -list masterDSN
Peer name Host name Port State Proto
---------------- ------------------------ ------ ------- -----
SUBSCRIBERDS MYHOST Auto Start 10
Last Msg Sent Last Msg Recv Latency TPS RecordsPS Logs
------------- ------------- ------- ------- --------- ----
0:01:12 - 19.41 5 52 2
Check replication state
Use the ttReplicationStatus procedure to check state of the subscriber data store
with respect to its master. If the subscriber is in the Stop, Pause, or Failed state, use
the ttReplicationStatus procedure to reset the subscriber state to Start, as
described in "Setting the replication state of subscribers" in the Oracle TimesTen
In-Memory Database TimesTen to TimesTen Replication Guide.
Example 6–5 Obtain status of the subscriber data store from the master data store
Use ttReplicationStatus to obtain the status of the subscriberds data store
from its master data store, masterDSN, enter:
> ttIsql masterDSN
Command> CALL ttReplicationStatus ('subscriberds');