15.10 - Optimizing Job Performance with Sessions and Instances - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.