TTREP.REPLICATIONS

The REPLICATIONS table collects together general information about all replication schemes in which the local database participates. The table indicates whether a replication scheme was created by ttRepAdmin -upgrade or by a CREATE MATERIALIZED VIEW statement.

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
REPLICATION_ORIGIN	TT_CHAR(1) NOT NULL	How replication was created 'U' - for ttRepAdmin -upgrade 'C' - for CREATE REPLICATION (or a ttRepAdmin command that was translated into CREATE REPLICATION)
REPLICATION_VERSION	TT_INTEGER NOT NULL	The number of ALTER REPLICATION commands applied to this replication scheme after its initial creation
SOURCE_STORE_ID_ALIGN	TT_INTEGER NOT NULL	Internal use, to properly align the SOURCE_STORE_ID column
SOURCE_STORE_ID	TT_BIGINT NOT NULL	If this replication scheme was created by restoring it from a backup: the database ID of the database from which this replication scheme was backed up and restored Otherwise -1 (the invalid database ID)
CHECKSUM	TT_BIGINT	Indication of whether the replication scheme has been updated