Sessions and Instances - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
egk1499705348414.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

The values that you specify with the Update operator MinSessions and MaxSessions attributes are not the only factors that limit the number of sessions that the Update operator establishes with the Teradata Database. The other limiting factors are:

  • The Teradata Database limit of one session per available AMP
  • The platform limit on the maximum number of sessions per application.
    • On network-attached client systems for UNIX, Linux, and Windows systems, this value is defined in the COP Interface software file, clispb.dat, under the max_num_sess variable.
    • On mainframe-attached z/OS client systems, this value is defined in the HSHSPB parameter under the IBCSMAX setting.
    • On mainframe-attached z/OS client system, use the TDP SET MAXSESSIONS command to specify a platform limit.
  • The limit of the network protocol software on network-attached systems

When the Update operator executes, the actual session limit is determined by the first limiting factor that is encountered.