Replication Status
Use this form of ttRepAdmin
to check the size of the transaction log files, bookmark position, or replication configuration of a master database.
ttRepAdmin -log {DSN | -connStr connection_string} ttRepAdmin -showstatus -detail {-awtmoninfo} {DSN | -connStr connection_string} ttRepAdmin -showconfig {DSN | -connStr connection_string} ttRepAdmin -bookmark {DSN | -connStr connection_string}
Options
The ttRepAdmin
monitor operations have the options:
Option | Description |
---|---|
|
Indicates the data source name of the master database. |
|
If you have enabled monitoring for AWT cache groups by calling the If AWT monitoring is enabled,
|
|
Specifies the connection string of the master database, an ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings. |
|
Indicates whether the replication agent transmitters and receivers are using TLS (indicated as SSL) |
|
Prints out number and size of transaction log files retained by replication to transmit updates to other databases. |
|
Lists the entire replication configuration. See Show the Configuration of Replicated Databases in Oracle TimesTen In-Memory Database Replication Guide Oracle TimesTen In-Memory Database Replication Guide for more information. |
|
Reports the current status of the specified replicated database. See Use ttRepAdmin to Show Replication Status in Oracle TimesTen In-Memory Database Replication Guide for more information. |
|
Reports the latest marker record from where replication must read the log, the most recently created log sequence number, and the latest log sequence number whose record has been flushed to disk. Bookmarks are not supported if you have configured parallel replication. See Show Replicated Log Records in Oracle TimesTen In-Memory Database Replication Guide for more information. |
Result Set
If AWT monitoring is enabled, this utility displays the following information in addition to other ttRepAdmin -showstatus
output.
-
TimesTen processing time: The total number of milliseconds spent in processing AWT transaction data since monitoring was enabled.
-
Oracle bookmark 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 the Oracle database.
-
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 the Oracle database.
-
Time since monitoring was started.
-
Total number of TimesTen row operations: The total number of rows updated in AWT cache groups since monitoring was enabled.
-
Total number of TimesTen transactions: The total number of transactions in AWT cache groups since monitoring was enabled.
-
Total number of flushes to Oracle: The total number of times that TimesTen data has been sent to the Oracle database.
The output also includes the percentage of time spent on TimesTen processing, Oracle bookmark, Oracle execution and Oracle commits.
See Use ttRepAdmin to Show Replication Status in Oracle TimesTen In-Memory Database Replication Guide for more information.
Examples
% ttRepAdmin -log DSN
The above syntax reports the number of transaction log files that replication is retaining to transmit updates to other databases. The replication agent retains a transaction log file until all updates in that transaction log file have been successfully transferred to each subscriber database.
% ttRepAdmin -showconfig DSN
The above syntax reports the entire replication configuration. It lists all the subscribers for the specified DSN, the names and details of the tables being replicated, and all the subscriptions.
% ttRepAdmin -showstatus DSN
The above syntax reports the current state of the database for the specified DSN. The output includes the state of all the threads in the replication agents for the replicated databases, bookmark locations, port numbers, and communication protocols.
For example, consider how to use the ttRepAdmin -showstatus
utility to display status for a unidirectional replication scheme from the rep1
database to the rep2
database.
The first ttRepAdmin
-showstatus
output shows the status of the rep1
database and its TRANSMITTER
thread. The second output shows the status of the rep2
database and its RECEIVER
thread.
% ttRepAdmin -showstatus rep1 DSN : rep1 Process ID : 1980 Replication Agent Policy : MANUAL Host : MYHOST RepListener Port : 1113 (AUTO) Last write LSN : 0.1487928 Last LSN forced to disk : 0.1487928 Replication hold LSN : 0.1486640 Replication Peers: Name : rep2 Host : MYHOST Port : 1154 (AUTO) Replication State : STARTED Communication Protocol : 12 TRANSMITTER thread(s): For : rep2 Start/Restart count : 2 Send LSN : 0.1485960 Transactions sent : 3 Total packets sent : 10 Tick packets sent : 3 MIN sent packet size : 48 MAX sent packet size : 460 AVG sent packet size : 167 Last packet sent at : 17:41:05 Total Packets received: 9 MIN rcvd packet size : 48 MAX rcvd packet size : 68 AVG rcvd packet size : 59 Last packet rcvd'd at : 17:41:05 Earlier errors (max 5): TT16060 in transmitter.c (line 3590) at 17:40:41 on 08-25-2004 TT16122 in transmitter.c (line 2424) at 17:40:41 on 08-25-2004
The replication status for the rep2
database should look similar to the following:
> ttRepAdmin -showstatus rep2 DSN : rep2 Process ID : 2192 Replication Agent Policy : MANUAL Host : MYHOST RepListener Port : 1154 (AUTO) Last write LSN : 0.416464 Last LSN forced to disk : 0.416464 Replication hold LSN : -1.-1 Replication Peers: Name : rep1 Host : MYHOST Port : 0 (AUTO) Replication State : STARTED Communication Protocol : 12 RECEIVER thread(s): For : rep1 Start/Restart count : 1 Transactions received : 0 Total packets sent : 20 Tick packets sent : 0 MIN sent packet size : 48 MAX sent packet size : 68 AVG sent packet size : 66 Last packet sent at : 17:49:51 Total Packets received: 20 MIN rcvd packet size : 48 MAX rcvd packet size : 125 AVG rcvd packet size : 52 Last packet rcvd'd at : 17:49:51
% ttRepAdmin -bookmark DSN
The above syntax prints out the log sequence numbers of the earliest log record still needed by replication, the last log record written to disk, and the last log record generated.
% ttRepAdmin -showstatus -awtmoninfo database1 [other -showstatus output] ... AWT Monitoring statistics -------------------------- TimesTen processing time : 0.689000 millisecs (0.164307 %) Oracle bookmark time : 3.229000 millisecs (0.770027%) Oracle execute time : 342.908000 millisecs (81.774043 %) Oracle commit time : 72.450000 millisecs (17.277315 %) Time since monitoring was started: 8528.641000 millisecs Cache-connect Operational Stats : Total Number of TimesTen row operations : 2 Total Number of TimesTen transactions : 2 Total Number of flushes to Oracle : 2
The above syntax and output shows the AWT monitoring status.
Notes
The ttRepAdmin
utility is supported only for TimesTen Data Manager DSNs. It is not supported for TimesTen Client DSNs.
You must use the -scheme
option when specifying more than one replication scheme, or when more than one scheme exists involving the specified database.
Using SQL configuration, you can create multiple replication schemes in the same database. If there is only one replication scheme, the ttRepAdmin
utility automatically determines the scheme. If there is more than one scheme, you must use the ttRepAdmin -scheme
option to specify which scheme to use.
When configuring replication for databases with the same name on different hosts, you can indicate which database you want to operate on by using -host
. For example, if all the subscribers have the name DATA
, you can set the replication state on host SW1
with:
% ttRepAdmin -receiver -name DATA -host SW1 -state start DSN
See Also
- For a full description of TimesTen Replication, see Oracle TimesTen In-Memory Database Replication Guide.
- For upgrade examples, see Upgrades in TimesTen Classic in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.