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

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
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> --| ;