SEQUENCER STATUS Command | unityadmin | Teradata Unity - SEQUENCER STATUS - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

Purpose

Displays information on the High-Availability (HA) status of the Unity servers.

Syntax

SEQUENCER STATUS ;

Output Values

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

Label Description
HA Status
  • Not Enabled
  • In Peer
  • Not in Peer
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.
Process Identifier State of each Sequencer provided when at least one Watchdog is connected.

Examples

The following example shows output if High Availability is enabled.

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

Individual Sequencer States
---------------------------
        unity1:5344                     : ACTIVE
        unity2: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 Unityadmin 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 High Availability is not enabled.

unityadmin>  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 Unityadmin connection

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

unityadmin> 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.