Passive Routing Session Requirements | Teradata Unity - Passive Routing Session Requirements - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

A passive routing session is opened on one system only.

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 running a load utility that opens multiple data sessions, only a routing rule that directs those sessions to a single system is allowed. Routing rules that load balance sessions across multiple systems are not allowed, because they would attempt to connect and load data across those specified systems. If a user attempts to run a load job using a LU, RR, or WRR PASSIVE routing rule with multiple systems, it is rejected with an error.