16.20 - The Effect of Operator Instances on the MaxSessions Value - 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

The number of sessions specified by the value of the operator MaxSessions attribute are balanced across the number of operator instances. For example, if the Update operator is defined with two instances, and the MaxSessions attribute is set to 4, each instance of the defined Update operator will run two sessions, provided there are at least four AMPs on the system.

An Update operator uses a maximum of one session per available AMP on the Teradata Database system. This means that if your Teradata Database system has ten available AMPs, the MaxSessions value must be less than or equal to ten.