Example of Passive Routing Behavior | Teradata Unity - Examples of Passive Routing Behavior - 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
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