Switch Server Mode Status | Teradata Data Mover - 17.11 - Use Case: Switch a Server from Standby to Active - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
When a standby server is needed to run a job, it must first be dropped from the synchronization service and then switched to active mode.
Currently Data Mover does not block running jobs if a standby has not been dropped from synchronization service and running jobs on a standby server can cause the following when not dropped from the sync service:
  • A replication break between the active and this standby server due to a foreign key or primary key issue. The active server will continue to retry sending the data.
  • Jobs may not run successfully.
  1. Drop the standby server from the synchronization service using the steps in Use Case: Drop One Standby Server from the Synchronization Service.
  2. Start all Data Mover services on this server such as:
    • /etc/init.d/tdactivemq start
    • /etc/init.d/dmdaemon start
    • /etc/init.d/tdmrest start
    • /etc/init.d/dmagent start
  3. Run jobs on this newly active server.