Session Limits - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide - 17.20

Product
Parallel Transporter
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2022-10-11
dita:mapPath
fag1645201363032.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2516
Product Category
Teradata Tools and Utilities

The values that you specify with the Stream driver TD_MIN_SESSIONS and TD_MAX_SESSIONS attributes are not the only factors that limit the number of sessions that the Stream driver establishes with the database.

The other limiting factors are:
  • 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 Stream driver executes, the actual session limit is determined by whichever limiting factor is encountered first.