Adding a Passive Routing Rule - 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
  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 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
    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.

    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.

    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, next on TD3, and the fourth on TD1, and so on.

    Weighted Round Robin Session are opened a defined number of times on the first system, then sessions are opened on the next system the defined number of times, and so on. Ordered system list: TD1x10, TD2x3, TD3x1

    The first 10 sessions are opened on TD1, next 3 sessions are opened on TD2, next session on TD3, and then the next 10 sessions are opened on TD1, and so on.

  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.