1. Replication Guide
  2. Defining an Active Standby Pair Replication Scheme
  3. Overview of Master Database States

Overview of Master Database States

Overview of the possible states of a master database.

These states are referenced in the tasks described in the rest of the chapter.

The master databases can be in one of the following states:

  • ACTIVE - A database in this state is the active database. Applications can update its replicated tables.

  • STANDBY - A database in this state is the standby database. Applications can update only nonreplicated tables in the standby database. Nonreplicated tables are tables that have been excluded from the replication scheme by using the EXCLUDE TABLE or EXCLUDE CACHE GROUP clauses of the CREATE ACTIVE STANDBY PAIR statement.

  • FAILED - A database in this state is a failed master database. No updates can be replicated to it.

  • IDLE - A database in this state has not yet had its role in the active standby pair assigned. It cannot be updated. Every database comes up in the IDLE state.

  • RECOVERING - When a previously failed master database is synchronizing updates with the active database, it is in the RECOVERING state.

You can use the ttRepStateGet built-in procedure to discover the state of a master database.