TTREP.REPELEMENTS

The REPELEMENTS table describes elements in a replication scheme.

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
ELEMENT_NAME	TT_CHAR(31) NOT NULL	The replication name for this element This is logically different from the DS_OBJ_NAME of the underlying data base object. For example, the ELEMENT_NAME for a replicated table may differ from the table name. This name must be unique in a replication scheme.
ELEMENT_TYPE	TT_CHAR(1) NOT NULL	The type of this replication element 'T' – table 'D' – database 'S' – sequence
OWNED_BY_SYSTEM	BINARY(1) NOT NULL	0x01 - if element is maintained by the system and cannot be directly referenced by SQL statements 0x00 - if element is defined and maintained by a user
MASTER_ID	TT_BIGINT NOT NULL	The TT_STORE_ID for the master or propagator of this element
OLD_MASTER_ID	TT_BIGINT NOT NULL	The TT_STORE_ID for the immediately preceding MASTER for this element -1 if none
IS_PROPAGATOR	BINARY(1) NOT NULL	Propagator flag 0 - The MASTER_ID identifies a true MASTER database. 1 - The MASTER_ID identifies a PROPAGATOR.
DS_OBJ_NAME	TT_CHAR(31) NOT NULL	If this replication refers to a single, underlying data base object: name of the object Specifically, it is the name of the replicated table if ELEMENT_TYPE = 'T'. It is NULL if ELEMENT_TYPE = 'D'. DS_OBJ_OWNER.DS_OBJ_NAME need not be unique in a replication scheme, but each occurrence must be associated with a distinct ELEMENT_NAME.
DS_OBJ_OWNER	TT_CHAR(31) NOT NULL	The owner of the replication element – if defined NULL otherwise This is always the owner of the table. DS_OBJ_OWNER.DS_OBJ_NAME need not be unique in a replication scheme, but each occurrence must be associated with a distinct ELEMENT_NAME.
DS_OBJ_ID	TT_BIGINT	Object ID or flag If the ELEMENT_TYPE = 'T': Table ID - If the table is in the owning (master or propagator) database, then this is the table ID. 1 - Table is in the subscriber database. If the ELEMENT_TYPE = 'D': 0 - Database is a master or propagator. 1 - Database is a subscriber. NULL - Database has been migrated, restored, or upgraded from an earlier version.
DURABLE_TRANSMIT	BINARY(1) NOT NULL	Durable transaction status 0 - Transactions are not made durable before they are transmitted. 1 - Transactions are made durable before they are transmitted (default).
CONFLICT_CHECKS	BINARY(8) NOT NULL	A bit map indicating which conflict detectors are enabled 0x0000000000000000 - no configured conflict detector (default) 0x0000000000000001 - ROW TIMESTAMP conflict detector
TS_COLUMN_NAME	TT_CHAR(31)	The name of the timestamp column specified in the CHECK CONFLICTS clause of a CREATE REPLICATION statement This column must be of type BINARY(8) and permit NULL values.
TS_EXCEPTION_ACTION	TT_CHAR(1) NOT NULL	The action to take upon detecting a conflict by a timestamp-based detector The action is specified by the ON EXCEPTION clause in the CHECK CONFLICTS clause of a CREATE REPLICATION statement. They appear in this column as: '\0' - action not defined 'N' - NO ACTION 'R' - roll back transaction (default)
TS_UPDATE_RULE	TT_CHAR(1) NOT NULL	The rule for maintaining the timestamp for a timestamp-based conflict detector '\0' - rule not defined 'U' - by user 'S' - by system (default)
TS_REPORT_FILE	TT_VARCHAR(1000) NOT INLINE	The name of the file to which the replication agent reports timestamp conflicts This file is specified by the REPORT TO clause in the CHECK CONFLICTS clause of a CREATE REPLICATION statement.
DS_OBJ_CREATION_CTN	BINARY (16) NOT NULL	Reserved for internal use.
IS_MASTER_PROPAGATOR	BINARY(1)	Indication of whether the database is both a master and a propagator
EXTERNAL_DB	TT_CHAR(1)	Indication of replication to a database that is not TimesTen NULL - no replication to another kind of database O - replication to Oracle database, which occurs in a TimesTen database with an AWT cache group
REPORT_FORMAT	TT_CHAR(1)	The report format for the replication conflict file 'S' - standard format 'X' - XML format NULL - no report file specified, therefore no format