Advanced Settings | Data Mover Portlet | Teradata Data Mover - 17.10 - About Advanced Job Settings - 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)
You can select advanced job save options from the Job Settings tab. Click Advanced to access job performance settings. Data Mover provides default values for these settings.
Teradata Systems
For Teradata systems, you can select these advanced job save options:
Data Streams
  • For DSA jobs, specify the number of streams per database node. If no value is specified, Data Mover does not generate a default value and DSC determines the soft stream limit at run time.
  • For Teradata PT API jobs, specify the number of data streams to use between the source and target databases. If no value is specified, Data Mover generates a default value based on the size of the tables being copied and the number of available AMPs.
  • All other utilities use a single data stream.
Source Sessions
Specifies the number of sessions per data stream for the source system. The following occurs when no value is specified:
  • For TPT jobs, a default value is generated based on the size of the tables being copied and the number of AMPs available.
  • Settings do not apply to jobs using other copy methods such as DSA.
Target Sessions
Specifies the number of sessions per data stream for the target system. The following occurs when no value is specified:
  • For TPT jobs, a default value is generated based on the size of the tables being copied and the number of AMPs available.
  • Settings do not apply to jobs using other copy methods such as DSA.
Max Agents per Task
Specifies the maximum number of agents that Data Mover allocates at the same time to one task in jobs that use the Teradata PT API. If multiple agents are installed in the Data Mover environment, you can enter an integer value greater than one to improve performance for a job that copies large amounts of data. If you do not provide a value for Max Agents per Task, Data Mover dynamically calculates a value at runtime.
Force Utility
Forces Data Mover to use a specific Teradata utility or API operator for the copy job. Data Mover automatically selects the best utility for the job.
Source Character Set
Specifies the session character set that is used to communicate with the source system.
Target Character Set
Specifies the session character set that is used to communicate with the target system.
Target Group Name
Specifies a shared pipe target group to run DSA jobs instead of having Data Mover automatically select one. If the specified target group does not exist, the job fails.
Parallel Builds
Specifies the number of tables with indices that can be built concurrently when using DSA. The maximum number of concurrent builds is 5 (default value).