16.20 - Determining the Optimum Number of Sessions - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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. However, this may not be optimal for every job. For some jobs, the default parallelism may be excessive. In other cases, there may not be enough available AMPs to provide the sessions necessary to run the job efficiently. Teradata PT provides the following attributes to optimize session usage for the five operators that support session limits.

  • MaxSessions determines the maximum number of sessions an operator can use.
  • MinSessions, determines the minimum number of sessions that must be available in order for the job to run.