Adding a Passive Routing Rule - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
ipb1476817227329.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
  1. In the Unity Setup portlet, click the Session Routing tab.
  2. Select the Routing Rules tab.
  3. Click .
  4. Next to Routing Rules, click .
  5. In Rule Name, type the name for this rule. Create a name that identifies the type of routing used for sessions that match this rule. For example, passiveSystemX indicates this rule is for Passive routing.
  6. In Routing Type, select Passive.
  7. If writes are allowed for objects that are managed in the Data Dictionary, check the box next to Allow writes to managed objects.
  8. Select the Balancing method.
    Balancing Method Name Description Example
    Round Robin Each session is opened on the next system in the specified order.

    Ordered system list: TD1, TD2, TD3

    First session is opened on TD1, next on TD2, third on TD3 and the fourth will be opened on TD1, and so on.

    Least Used Each session is opened on the system that has the least number of open connections at that time.

    Ordered system list: TD2, TD3

    Each session is opened on either TD2 or TD3, given whichever has the smaller number of open sessions at the time.

    First Available From the ordered system list, the first available system is used to establish the session.

    Ordered system list: TD1, TD2, TD3

    Each session is attempted first on TD1. If the session fails, the session is attempted on TD2 and then TD3, in order.

  9. Select the systems to include in the routing rule. To reorder the systems in the list, click and drag the icon on the left of the system ID.
  10. In Error Profile, select the associated Error profile.
  11. Click Save. The new routing rule is added to the summary table.