Optimizing Job Performance with Sessions and Instances - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
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 database session for each AMP configured on the 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
  • Stream
  • Update

The following sections discuss how to optimize the specification of instances and sessions in a job script.