Examples of Passive Routing Behavior - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
User mappings and routing rules define how session routing occurs based on its logon properties. This table shows examples of passive routing rules and how different balancing methods determine different session routing strategies.
Passive Routing Rule Access System Balancing Method Error Profile
RoutingPassive1 TD1, then if it fails, TD2 First Available DefaultProfile
RoutingPassive2 TD4, TD3, TD4, TD1

The least used opens first session each time.

Least Used DefaultProfile
RoutingPassive3 TD1, TD2, TD3 then TD1, TD2, TD3

One session is opened per system in order.

Round Robin DefaultProfile
RoutingPassive4 TD1x10, TD2x3, TD3x1 then TD1x10, TD2x3, TD3x1

Sessions are opened the defined number of times on the first system, then sessions are opened on the next system the defined number of times, and so on.

Weighted Round Robin DefaultProfile