Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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 store and other stores 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 store 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_INTEGER 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_INTEGER 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_INTEGER The log file number of the highest TT_STORE_ID log sequence number sent to and acknowledged by SUBSCRIBER_ID.
SENDLSNLOW TT_INTEGER The log file offset of the highest TT_STORE_ID log sequence number sent to and acknowledged by SUBSCRIBER_ID.
REPTABLESLSNHIGH TT_INTEGER For TimesTen internal use.
REPTABLESLSNLOW TT_INTEGER 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 store TT_STORE_ID.
DISKLESS_UNINITIALIZED BINARY (1) 0 if TT_STORE_ID is either disk-based or is diskless and has not initialized SUBSCRIBER_ID for diskless replication. 1 otherwise.
CTNLISTINDEX TT_INTEGER For internal use by the replication agent.