Technical data

Replication does not work
5-2 Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide
Replication does not work
If you are unable to get replication working, the problem may be one or more of the
following:
Using SNMP traps for notification of replication events
TimesTen can send SNMP traps for certain replication events to enable network
management software to take immediate action. TimesTen can send the following
SNMP traps:
■ ttRepAgentExitingTrap
■ ttRepAgentDiedTrap
■ ttRepAgentStartingTrap
These traps are described in "Diagnostics through SNMP Traps" in the Oracle TimesTen
In-Memory Database Error Messages and SNMP Traps.
Monitoring AWT performance
You can monitor the performance of asynchronous writethrough (AWT) cache groups
to determine how much time is spent performing tasks in the AWT workflow. Use the
ttCacheAwtMonitorConfig built-in procedure to enable monitoring.
For example, enable monitoring and set the sampling frequency to 16. A sampling
factor of 16 is recommended for accuracy and performance.
Command> CALL ttCacheAwtMonitorConfig('ON',16);
< ON, 16 >
1 row found.
Use the ttRepAdmin utility with the -awtmoninfo and -showstatus commands to
display the monitoring results. The AWT monitoring statistics include:
■ TimesTen processing time: The total number of milliseconds spent in processing
AWT transaction data since monitoring was enabled.
■ Oracle bookmark management time: The total number of milliseconds spent in
managing AWT metadata on Oracle since monitoring was enabled.
■ Oracle execute time: The total number of milliseconds spent in OCI preparation,
binding and execution for AWT SQL operations since monitoring was enabled.
This statistic includes network latency between TimesTen and Oracle.
■ Oracle commit time: The total number of milliseconds spent in committing AWT
updates on Oracle since monitoring was enabled. This statistic includes network
latency between TimesTen and Oracle.
■ Time since monitoring was started
Possible Cause See...
TimesTen daemon or replication agents not
running
"Check status of TimesTen daemon and
replication agents" on page 6-3
Replication agents not communicating "Check that replication agents are
communicating" on page 6-5
Replication not in Start state "Check replication state" on page 6-5