SQL Update Logging on Standby Server | High Availability | Teradata Data Mover - Logging SQL Updates on the Standby Server - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

When you start the standby synchronization service, dmSyncSlave.json is created in the specified path as defined by the value of sql.log.directory in sync.properties. The service writes the SQL updates to the file /var/opt/teradata/datamover/logs/dmSyncSlave.json. The standby synchronization service writes SQL statements that the active service sends to dmSyncSlave.json, after which the standby service runs the SQL statements using another service on the standby repository. After all SQL statements are run, dmSyncSlave.json is deleted. If any SQL statements fail to run, a TVI alert is triggered.