Passive Routing Session Requirements - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

A passive routing is opened on exactly one system.

If more than one system is specified in the passive routing rule, a system is chosen based on least used (LU), round robin (RR), weighted round robin (WRR), or first available. If RR is specified, the session open is attempted on the first session in the list of systems associated with the rule.

When executing a load utility that opens multiple data sessions, only a routing rule that directs those sessions to a single system are allowed. Routing rules that load balance sessions across multiple systems are not allowed, since they would attempt to connect and load data across those specified systems. If a user attempts to execute a load job in using a LU, RR, or WRR PASSIVE routing rule with multiple systems, it is rejected with an error.