Stream Operator Environment Variables | Teradata Parallel Transporter - Environment Variables - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities
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
  • Vantage 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.