ttRepStateGet

Description

Indicates the current replication state of a data store in an active standby pair.

Required privilege

This procedure requires no privilege.

Syntax

ttRepStateGet()

Parameters

ttRepStateGet has no parameters.

Result set

ttRepStateGet returns the result:

Column Type Description

Column	Type	Description
`state`	TT_VARCHAR (20) NOT NULL	The current replication state of the data store. One of: `ACTIVE` - The data store is currently the active master data store. Applications may update its replicated tables `STANDBY` - The data store is the standby master data store. Applications may only update its non-replicated tables. `FAILED` - The data store is a failed master data store. No updates are replicated to it. `IDLE` - The data store has not yet been assigned its role in the active standby pair. It cannot be updated by applications or replication. Every store comes up in the IDLE state `RECOVERING` - The store is in the process of synchronizing updates with the active store after a failure.

state

TT_VARCHAR (20) NOT NULL

The current replication state of the data store. One of:

ACTIVE - The data store is currently the active master data store. Applications may update its replicated tables

STANDBY - The data store is the standby master data store. Applications may only update its non-replicated tables.

FAILED - The data store is a failed master data store. No updates are replicated to it.

IDLE - The data store has not yet been assigned its role in the active standby pair. It cannot be updated by applications or replication. Every store comes up in the IDLE state

RECOVERING - The store is in the process of synchronizing updates with the active store after a failure.

Examples

To determine whether the standby data store in an active standby pair has moved from the IDLE to the STANDBY state, use:

CALL ttRepStateGet();
< STANDBY >