11 Managing Replication

This chapter describes some of the TimesTen utilities and built-in procedures you can use to monitor and manage the replication status of your databases.

You can manage and monitor replication from both the command line and within your programs. The ttStatus and ttRepAdmin utilities described in this chapter are useful for command line queries. To manage and monitor replication from your programs, you can use the TimesTen built-in procedures described in Built-In Procedures in Oracle TimesTen In-Memory Database Reference or create your own SQL SELECT statements to query the replication tables described in Replication Tables in Oracle TimesTen In-Memory Database System Tables and Views Reference.

Note:

You can only access the TimesTen SYS and TTREP tables for queries. Do not try to alter the contents of these tables.

This chapter includes the following topics:

• Show State of Replication Agents

• Replication of Statistics

• Set the Replication State of Subscribers

• Show Master Database Information

• Show Subscriber Database Information

• Show the Configuration of Replicated Databases

• Show Replicated Log Records

• Use ttRepAdmin to Show Replication Status

• Check the Status of Return Service Transactions

• Analyze Outstanding Transactions in the Replication Log