Session Limits - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.00
Published
November 30, 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
fcz1544831938753.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

The values that are specified with the Export driver TD_MAX_SESSIONS and TD_MIN_SESSIONS attributes are not the only factors limiting the number of sessions that the Export driver establishes with the database.

The other limiting factors are:
  • The database limit of one session per AMP.
  • The platform limit on the maximum number of sessions per application. 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. When the Export driver executes, the actual session limit is determined by whichever limiting factor is encountered first.
The Export driver terminates with an error message if one or more instance cannot log on.