17.10 - Session Limits - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Parallel Transporter
Release Number
Release Date
June 2021
Content Type
Programming Reference
Publication ID
English (United States)

The values you specify with the Update driver’s TD_MIN_SESSIONS and TD_MAX_SESSIONS attributes are not the only factors limiting the number of sessions the Update driver can establish with the database. When the Update driver executes, the actual session limit is determined by whichever limiting factor is encountered first.

The other limiting factors are:
  • The database limit of one session per AMP. This value is defined in the COP Interface software file, CLISPB.DAT, under the max_num_sess variable. You can use the TDP SET MAXSESSIONS command to specify a platform limit. The default TDP MAXSESS value is 1024 sessions.
  • The limit of the network protocol software on workstation-attached systems.