Optimizing Job Performance with Sessions and Instances - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job scripts can be constructed to maximize job performance by specifying multiple instances of an operator at the point where the operator is referenced in an APPLY statement. Operator instances then execute in parallel to complete the task.

Each operator used in a single-step job, or in a job step, will attempt to simultaneously log on to one Teradata Database session for each AMP configured on the Teradata Database system. This feature provides a high degree of parallelism to maximize operator performance.

The following operators can be configured to enhance job performance through the optimization of instances and sessions:

  • DataConnector (instances only)
  • Export
  • Load
  • SQL Inserter (instances only)
  • Stream (instances only)
  • Update
  • The following sections discuss how to optimize the specification of instances and sessions in a job script.