16.10 - Preventing Automatic Replication - 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

CDM replicates changes from client applications that are are non-deterministic. If you need changes that are not intended for replication, such as during regular maintenance on a single Teradata system, you can prevent automatic replication to other systems.

If you log on as a DBC user, any query performed is not replicated. Alternatively, if you set the following queryband for a session, the query is not replicated.

  1. Log on to unityadmin.
  2. SET QUERY_BAND='CDCPREPARE=NONE;' FOR SESSION;