16.10 - Environment Variables - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

Most environmental variables are difficult to control or modify. They include such things as:

  • Whether the Stream operator is running on a TPA-node, non-TPA node, or an external client
  • The power of the client platform
  • The size of the pipe (network or channel) between the client and the database
  • Number of nodes and CPU power of the server
  • The Stream operator client software version
  • Teradata Database software version

Environmental variables become particularly important to consider when you are testing in one environment, and planning on moving a Stream operator job into production in an entirely different environment. Performance expectations based on a set of the Stream operator’s parameters that were optimized on a 1-node Teradata test system, are unlikely to be entirely effective when moved to a 20-node production system with a more powerful client and wider network bandwidth. Some parameter settings will have to be rethought moving from test to production.