Configure the Synchronization Service | Teradata Data Mover - Configuring the Synchronization Service - Teradata Data Mover

Teradata® Data Mover Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Data Mover
Release Number
17.05
Published
October 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
iak1591023586907.ditamap
dita:ditavalPath
stp1591127384938.ditaval
dita:id
B035-4102
lifecycle
previous
Product Category
Analytical Ecosystem
When configuring the sync service, do not have running jobs on either the active or standby servers and make sure the repositories are in synchronization. You can synchronize the repositories using one of the following methods:
  • Before configuration: Run the backup_daemon and restore_daemon commands
  • During configuration: Let dmsync config perform the backup and restore during the configuration process
The dmsync config command does not check if there are running jobs when doing a backup and restore of the system. If this is a concern, run the Data Mover backup and restore commands before configuring the synchronization service.
  1. On the active repository server, go to cd /var/opt/teradata/postgres/data to change the Postgres configuration.
  2. In postgres.conf, change wal_level to logical.
    wal_level = logical
  3. Restart the active repository:
    • /etc/init.d/postgresql stop
    • /etc/init.d/postgresql start
  4. On the active server , edit the sync.properties file and set the sync.isMaster property to true.
  5. On the standby server, edit the sync.properties file and set the sync.isMaster property to false.
  6. On the active server, set the dm.pg.jobstore.production.host property in the sync.properties file as the hostname for the active server.
    Use a name other than localhost as the host name.
  7. On the active server, configure the sync service:
    /opt/teradata/datamover/sync/nn.nn/dmsync config
    Where nn.nn in the path refers to the version numbers of Data Mover.
  8. When prompted, respond to the following:
    1. Select the Setup Replication Service option.
    2. Provide the standby server name.
    3. On the standby server, provide the Postgres user credentials.
    4. Answer y or n to backup and restore the repository from the active to the standby server.
  9. Verify that /var/opt/teradata/logs/dmSync.log is configured properly and the sync monitor is running on the active server.
    The monitoring service automatically starts once the configuration process completes successfully.