Exclude Objects | Command Line | Teradata DSA - 17.20 - Excluding Objects - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
You can exclude objects from a backup or restore job by amending excludeobjectinfo in the XML file containing the job definition.
The following restrictions are true for backup or data migration jobs:
Version of DSA Teradata NewSQL Engine / Teradata Database Restricted Objects
Prior to DSA 16.20 Any Cannot exclude individual: VIEW, MACRO, TRIGGER, JOIN_INDEX, HASH_INDEX
DSA 16.20 Teradata Database prior to 16.20 Cannot exclude individual: VIEW, MACRO, TRIGGER, JOIN_INDEX, HASH_INDEX
  Advanced SQL Engine 16.20 or later Cannot exclude individual: JOIN_INDEX or HASH_INDEX

Use the job level option skip_joinhash_index to skip join and hash index. See create_job.

  1. Open the XML file containing the job definition information.
  2. Under excludeobjectinfo, specify the object name and object type that you want to exclude.
    For example, to exclude tables T1 and T2 from a job that restores database ABC:
    <objectinfo>
        <object_name>ABC</object_name> 
        <object_type>DATABASE</object_type>
        <parent_name>SYSTEMFE</parent_name>
        <parent_type>DATABASE</parent_type>
        <!--    Optional    --> 
        <exclude>
            <excludeobjectinfo>
                <object_name>T1</object_name> 
                <object_type>TABLE</object_type>
            </excludeobjectinfo>
            <excludeobjectinfo>
                <object_name>T2</object_name> 
                <object_type>TABLE</object_type> 
            </excludeobjectinfo>
        </exclude>
    </objectinfo>