SEQUENCER STATUS Command | bcmadmin | Teradata Business Continuity Manager - SEQUENCER STATUS - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide

Product
Teradata Business Continuity Manager
Release Number
1.0
Published
January 2022
Language
English (United States)
Last Update
2022-01-27
dita:mapPath
otc1639627713801.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Displays information on the HA status of the Business Continuity Manager servers.

Syntax

SEQUENCER STATUS ;

Output Values

The following table describes output that display after running SEQUENCER STATUS.

Label Description
HA Status High availability status of the Business Continuity Manager. The state of individual sequencer processes on each paired Business Continuity Manager server determines HA status.

The status can be one of the following:

  • Not Enabled: Indicates the Business Continuity Manager servers are not paired for high availability.
  • In Peer: Indicates one of the sequencer processes is in the Active state, and the other is in the Standby Synchronized state.
  • Not in Peer: Indicates the Business Continuity Manager servers are paired, but the sequencer process cannot perform an automatic failover.
  • Establishing Peer: Indicates the Business Continuity Manager servers are paired, but the sequencer process cannot perform an automatic failover.
  • Split Brain: Indicates the Business Continuity Manager servers are paired, but the sequencer process cannot perform an automatic failover.

You must intervene if the sequencer process cannot perform an automatic failover.

Log Replication Mode (HA only) This label only displays for HA installations. The output can be one of the following:
  • Asynchronous
  • Near synchronous
  • Synchronous
Individual Sequencer States State of each sequencer, which can be one of the following:
  • ACTIVE
  • DISABLED
  • DOWN
  • INACTIVE
  • STANDBY (SYNCHRONIZING/UNSYNCHRONIZED)
  • STANDBY (SYNCHRONIZED)
  • UNKNOWN
  • WAITING
Log Percentage to Sync The percentage of log pending synchronization from the active sequencer to the standby sequencer. Possible values:
  • Percentage pending
  • Unavailable
Sequencer State Counts (HA only) Number of sequencers in Active and Standby states.
Process Identifier State of each sequencer provided when at least one Watchdog is connected.

The following table describes the relationship between the states of both sequencer processes and the resulting paired HA status.

Sequencer State Combination Paired HA Status
Down Waiting Not in Peer: Waiting for sequencer startup
Waiting Waiting Establishing Peer: Waiting for sequencers
Active Standby-Synchronizing Establishing Peer: Synchronizing
Active Standby In Peer
Active Standby-Unsynchronized Not in Peer: Cannot failover
Active Down Not in Peer: Cannot failover
Down Standby-Unsynchronized Not in Peer: Cannot failover
Active Active Split Brain
Disabled Disabled Split Brain

Examples

The following example shows output if HA is enabled.

bcmadmin>  SEQUENCER STATUS; 
HA Status             : In Peer
Log Replication Mode  : Asynchronous
Log Percentage to Sync: 0
Failover Mode         : Manual

Individual Sequencer States
---------------------------
        BCM1:5344                     : ACTIVE
        BCM2:5344                     : STANDBY (SYNCHRONIZED)


Sequencer State Counts
----------------------

        Active Count                    : 1
        Standby (Synchronized) Count    : 1

---------------------------------------------
Process Identifier   : region2_seq
Process Type         : Sequencer
Region Name          : region2
Current Status       : Up - Processing this bcmadmin connection
---------------------------------------------
Process Identifier   : region1_seq
Process Type         : Sequencer
Region Name          : region1
Current Status       : Up
---------------------------------------------
Process Identifier   : region1_wdg
Process Type         : Watchdog
Region Name          : region1
Current Status       : Up
---------------------------------------------
Process Identifier   : region2_wdg
Process Type         : Watchdog
Region Name          : region2
Current Status       : Up

The following example shows output if HA is not enabled.

bcmadmin>  SEQUENCER STATUS;  
HA Status            : Not enabled
Log Replication Mode  : Asynchronous
Failover Mode         : Manual

---------------------------------------------
Process Identifier   : region1_seq
Process Type         : Sequencer
Region Name          : region1
Current Status       : Up - Processing this bcmadmin connection

The following example shows the percentage of log pending synchronization from the active sequencer to the standby sequencer.

bcmadmin> sequencer status;
HA Status               : Synchronizing
Log Replication Mode    : Asynchronous
Log Percentage to sync  : 1.84
Failover Mode           : Automatic
The Log Percentage to Sync is displayed at the active sequencer only if another peer sequencer is connected to the cluster.