ttReplicationStatus
This procedure returns the status of one or more replication peer databases.
Required Privilege
This procedure requires no privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttReplicationStatus(['subscriber'], ['hostname'])
Parameters
ttReplicationStatus
has the optional parameters:
Parameter | Type | Description |
---|---|---|
|
|
Subscriber of interest or |
|
|
The host name of one or more stores that are configured to receive updates from the executing store; if |
Result Set
ttReplicationStatus
returns the result set:
Column | Type | Description |
---|---|---|
|
|
Subscriber name. |
|
|
Name of the system that hosts the subscriber. |
|
|
TCP/IP port used by the subscriber agent to receive updates from the master. A value of 0 indicates replication has automatically assigned the port. |
|
|
Current replication state of the subscriber with respect to its master database. The values of the result column are:
|
|
|
Number of transaction log files the master database is retaining for a subscriber. |
|
|
Seconds since last interaction or |
|
|
Name of replication scheme. |
|
|
Owner of replication scheme. |
Examples
Command> call ttReplicationStatus(); < MASTER2, HOST1, 0, start , 1, 257142, \ _ACTIVESTANDBY , TTREP > 1 row found. Command> call ttReplicationStatus('master2', 'host1'); < MASTER2, HOST1, 0, start , 1, 266439, \ _ACTIVESTANDBY , TTREP > 1 row found.
Notes
-
If the
receiver
parameter is notNULL
, only the status of the given receiver is returned. If thereceiver
parameter isNULL
, the status of all subscribers is returned. -
This procedure is supported only for TimesTen Data Manager ODBC applications. It is not supported for TimesTen Client or JDBC applications.
See Also
- ttRepDeactivate
- ttRepPolicySet
- ttRepStop
- ttRepSubscriberStateSet
- ttRepSyncGet
- ttRepSyncSet
- ttRepTransmitSet
- ttRepDuplicateEx in Oracle TimesTen In-Memory Database C Developer's Guide