Specify copyStats at Job Level | Teradata Data Mover - 17.10 - Specifying Copy Statistics at Job Level - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)
Specifying copyStats at the job level allows for copying statistics in bulk instead of individually at the object level. When enabled, all tables and indexes (hash or join) in the job inherit the statistics at the job level. If a different value is specified at the table or index (hash or join) level, the job-level value is overridden.
  1. In the job definition, set copyStats to true as in the following example:
    <dmCreate>
    ...
    <copyStats>true</copyStats>
    <database selection="unselected">
    	<name>database1</name>
    	<table selection="included">
    		<name>test</name>
    		<validate_row_count>all</validate_row_count>
    	</table>
    </database>
    ...
    </dmCreate>