TTREP.REPPEERS

The REPPEERS table displays status information about the stores in a replication scheme. After the initial upgrade, the REPPEERS table contains peer information only about the local database and other databases that it transmits updates to.

Columns

Column name	Type	Description
REPLICATION_NAME	TT_CHAR(31) NOT NULL	Name for a replication scheme
REPLICATION_OWNER	TT_CHAR(31) NOT NULL	The replication scheme's owner
TT_STORE_ID	TT_BIGINT NOT NULL	Unique, system-generated identifier for a HOST_NAME/TT_STORE_NAME pair
SUBSCRIBER_ID	TT_BIGINT NOT NULL	The identifier for a database that subscribes to at least one replication element owned by TT_STORE_ID If a valid ID then this record describes the status of TT_STORE_ID/SUBSCRIBER_ID as a sender/subscriber pair.
COMMIT_TIMESTAMP	TT_BIGINT	Commit timestamp This field and COMMIT_SEQNUM together store the value of the Commit Ticket Number of the refreshed transaction that the subscriber has just committed.
COMMIT_SEQNUM	TT_BIGINT	Commit sequence number This field and COMMIT_TIMESTAMP together store the value of the Commit Ticket Number of the refreshed transaction that the subscriber has just committed.
SENDLSNHIGH	TT_BIGINT	The log file number of the highest TT_STORE_ID log sequence number sent to and acknowledged by SUBSCRIBER_ID
SENDLSNLOW	TT_BIGINT	The log file offset of the highest TT_STORE_ID log sequence number sent to and acknowledged by SUBSCRIBER_ID
REPTABLESLSNHIGH	TT_BIGINT	For TimesTen internal use
REPTABLESLSNLOW	TT_BIGINT	For TimesTen internal use
STATE	TT_INTEGER	The state of replication kept by TT_STORE_ID with respect to this SUBSCRIBER_ID 0 - START: Replication is in the active state and all log updates are retained until they have been applied at SUBSCRIBER_ID. 1 - PAUSE: Replication is not in the active state but all log updates are retained until they have been applied at SUBSCRIBER_ID. 2 - STOP: Replication is not in the active state and log updates are not retained. 4 - FAILED: Replication is not in the active state, log updates are not retained, and the log updates that need to be retained exceed the user defined threshold (TTREP.REPSTORES.FAIL_THRESHOLD). When this state has been communicated to SUBSCRIBER_ID it is changed to STOP.
TIMESEND	TT_INTEGER	The timestamp (in seconds) for the time of the last known successful transmission from TT_STORE_ID to SUBSCRIBER_ID
TIMERECV	TT_INTEGER	The timestamp (in seconds) for the time TT_STORE_ID last received a transmission from SUBSCRIBER_ID
PROTOCOL	TT_INTEGER	A number in the range 0 to 5 indicating the protocol level that replication uses for communication between TT_STORE_ID and SUBSCRIBER_ID A higher number indicates a newer protocol.
LATENCY	BINARY_DOUBLE	An estimate of the time interval (in seconds) from the commit of a transaction on TT_STORE_ID to its receipt of acknowledgement that it has been applied at the subscriber identified by SUBSCRIBER_ID
TPS	TT_INTEGER	An estimate of the number of transactions per second that are committed on TT_STORE_ID and successfully received by the subscriber identified by SUBSCRIBER_ID
RECSPERSEC	TT_INTEGER	An estimate of the number of records per second retrieved by the subscriber identified by SUBSCRIBER_ID from the database TT_STORE_ID
TRACK_ID	TT_TINYINT NOT NULL	ID of replication track used in user-specified parallel replication
CTNLISTINDEX	TT_INTEGER	For internal use by the replication agent