SEQUENCER PROMOTE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Switches an Active Sequencer to Standby state, and the Standby - Synchronized Sequencer to Active state. Use this command to swap the Active Sequencer within a Unity-managed configuration.

Syntax

SEQUENCER PROMOTE ;

Usage Considerations

This command only runs under the following conditions:

  • unityadmin is connected to the Standby Sequencer
  • Both Sequencers are UP and connected
  • Sequencers in the Unity-managed configuration are in Peer state. Run the SEQUENCER STATUS command to verify.
  • All Teradata Database systems are in Unrecoverable or Out of Service state

Example

unityadmin>  SEQUENCER PROMOTE; 
Operation Number : 3
Operation Name   : Sequencer Promote
User             : admin
User Name        : Apollo Frank
Start Time       : 10/17 16:59:00
Updates:
    10/17 16:59:00 [-] Info: Sending promote request
    10/17 16:59:03 [-] Info: Sequencer HA promote request succeeded
    10/17 16:59:03 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 10/17 16:59:03