TTREP.REPSUBSCRIPTIONS

The REPSBUBSCRIPTIONS table registers each subscribing database that maintains a secondary copy of a replication element.

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, logically distinct from the name of an underlying database object

SUBSCRIBER_ID

TT_BIGINT NOT NULL

The TT_STORE_ID for a subscriber to this element

A subscriber may not subscribe more than once to a replication element in a replication scheme.

RETURN_SERVICE

TT_CHAR(1) NOT NULL

Return service for this subscriber with respect to this replication element

'C' - RETURN COMMIT

'R' - RETURN RECEIPT

'\0' - no return services

'2' - RETURN TWOSAFE

RETURN_BY_REQUEST

BINARY(1) NOT NULL

The type of return services for this element

0 - Return services are provided unconditionally.

1 - Return services are provided only by request.

This field is ignored if RETURN_SERVICES = '\0'.

PRIVILEGES

TT_CHAR(1) NOT NULL

Privileges for this subscriber with respect to this replication element

'\0' - no special subscriber privileges