15.10 - Session Limits - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

prodname
Parallel Transporter
vrm_release
15.10
category
Programming Reference
featnum
B035-2516-035K

Session Limits

The values you specify using the TD_MIN_SESSIONS and TD_MAX_SESSIONS attributes are not the only factors limiting the number of sessions the Load driver establishes with the Teradata Database. When the Load driver executes, the actual session limit is determined by whichever limiting factor is encountered first.

The other limiting factors are:

  • The Teradata 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 network-attached systems.