ttRepStateSet

Description

Sets the replication state of a data store in an active standby pair replication scheme. Currently, ttRepStateSet may only be used to set the state of a data store to ACTIVE, indicating that it is to take the active role in an active standby pair. ttRepStateSet may only be executed in the following situations:

A data store has had a CREATE ACTIVE STANDBY PAIR command executed and no failures have occurred since.
A data store is currently in the STANDBY state, and the other data store in the active standby pair has had its state changed from ACTIVE to IDLE using the ttRepDeactivate procedure.
A data store has just recovered from the local transaction log and was in the ACTIVE state before it went down.

Required privilege

This procedure requires the ADMIN privilege.

Syntax

ttRepStateSet('state')

Parameters

ttRepStateSet has the parameter:

Parameter	Type	Description
`state`	TT_VARCHAR (20) NOT NULL	The replication state of the data store. Must be ACTIVE, in this release. Setting a store to ACTIVE designates it as the active data store in an active standby pair.

Result set

ttRepStateSet returns no results.

Examples

To set the replication state of the data store to ACTIVE, use:

CALL ttRepStateSet('ACTIVE');