Read-only Target | Teradata Data Mover - Read-Only Target - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Published
October 2021
Language
English (United States)
Last Update
2021-10-14
dita:mapPath
cai1626458602965.ditamap
dita:ditavalPath
cai1626458602965.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

To make sure that the source and target data are in sync for DELTA executions during incremental copy, DSA sets the target table to read-only after incremental FULL execution, also known as the incremental restore state.

User is not allowed to change target table data, including adding join or hash indexes, which results in Operation not allowed: table is in Incremental Restore (read-only) state.

  • If target system must be promoted during an emergency, such as a DR system standing in for a PROD system, user can set GDO 555IgnoreIncrementalRestoreState to true to make the entire system write enabled
  • If user only wants to make the target tables in an incremental job write enabled, user can start the job with parameter -ir_allow_write set to "true": datamove start -job_name my_ir_job -ir_allow_write true
  • Invoke a SQL statement to allow write for the read-only object:

    The syntax is:

    INCREMENTAL RESTORE ALLOW WRITE FOR

    |--<Databasename> --|

    |--<Databasename.TableName> --| ;