SEQUENCER STATUS - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
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
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
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


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