Session Limits - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
haz1691132518981.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ana1478611373864
lifecycle
latest
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.