16.10 - SEQUENCER PROMOTE - 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

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.
  • Unity repositories are synchronized (synced ). Run the REPOSITORY INFO 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