TTREP.TTSTORES

The TTSTORES table maps the host name and database name to a unique TT_STORE_ID. The TT_STORE_ID is a foreign key for all other replication schema tables that refer to a database in a replication scheme.

Columns

Column name	Type	Description
TT_STORE_ID	TT_BIGINT NOT NULL	Unique, system-generated identifier for a HOST_NAME/TT_STORE_NAME pair
HOST_NAME	TT_VARCHAR(200) NOT INLINE NOT NULL	Name of the participating host node
TT_STORE_NAME	TT_VARCHAR(200) NOT INLINE NOT NULL	The name for this database
IS_LOCAL_STORE	BINARY(1) NOT NULL	1 if this TT_STORE_ID represents the local database 0 otherwise
MAJOR_RELEASE	TT_INTEGER NOT NULL	The major release part of this database's TimesTen release number 0 indicates the current release.
MINOR_RELEASE	TT_INTEGER NOT NULL	The minor release part of this store's TimesTen release number
REP_SCHEMA_VERSION	TT_INTEGER NOT NULL	The version of the replication schema in this database
REP_PORT_NUMBER	TT_INTEGER NOT NULL	The port number that replication uses to communicate with this database This is 0 if automatically assigned.
RRPOLICY	TT_CHAR(1)	Subscribers affected by return service failure policy Supported values are: 'S' - single subscriber 'A' - all subscribers 'N' - no policy
RRTRIGGER	TT_INTEGER	Number of timeouts before the return service failure policy is triggered
RRRESUME_LATENCY	TT_INTEGER	Resume latency in milliseconds
RRDURABLE	BINARY(1)	Durable commits on RETURN RECEIPT failure Supported values are: 1 - true 0 - false
RET_LOCAL_ACTION	TT_CHAR(1)	Default commit behavior for RETURN TWOSAFE transactions 'C' - COMMIT 'N' - NO ACTION
RET_WAIT_TIME	TT_INTEGER	The defaulted timeout value for RETURN TWOSAFE transactions
RET_WHEN_STOPPED	BINARY(1)	Return service status If either the replication agent for the database is stopped or if the database is used as master and the replication agent for the database is set to STOP, then if the value of the column is a non-zero value, return services for the database are suspended.
COMPRESSION	TT_CHAR(1)	Y if all data from the database is compressed
MASTER	TT_CHAR(1)	Active or standby database or subscriber database Values are: 'Y' - active or standby database 'N' - subscriber database NULL - all other cases
ROLE	TT_CHAR(1)	Role 'A' - active 'S' - standby NULL - all other cases
TS	TT_BIGINT	The timestamp at which the specified role change was made
CONFLICT_REPORT_STOP	TT_INTEGER	The threshold at which conflict reporting is stopped
CONFLICT_REPORT_RESTART	TT_INTEGER	The rate at which conflict reporting is resumed
CONFLICT_REPORT_FLUSH_METHOD	TT_INTEGER	Reserved for future use
TABLECHECK	TT_CHAR(1)	Indication of exact or relaxed replication E (exact) - The table structures on the master and subscriber databases must be identical for replication to occur. R (relaxed) - Replication can occur between master and subscriber if a relaxed table check has been passed. This means that the number of columns and column data types match for the tables in the master and subscriber databases. NULL (default) - This is the value for all other cases.