16.10 - ROUTING LIST - 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

Purpose

List of existing routing rules and the properties that define each rule.

Syntax

ROUTING LIST <RoutingName>;

Parameters

RoutingName
Name of the routing rule. If you do not specify a routing rule name, all existing routing rule definitions display.

Examples

Routing rule definitions display in the following format:

<RoutingName>
(REJECT LOGON) |
([READ [ALL | <tdpid>[, <tdpid>, ...] [PREFERRED]]
[WRITE [ALL | <tdpid>[, <tdpid>, ...] [CREATE {PREFERRED | BALANCED}]]
[OPTIONS <OptionName>[, <OptionName>, ...]]
[ERRORLIST <ErrorListName>]) |
(PASSIVE [ALLOW MANAGED WRITES]
([LU] <tdpid>[, <tdpid>, ...] | RR <tdpid>[, <tdpid>, ...] [WEIGHTED <n1>[, <n2>, ...])
[ERRORLIST <ErrorListName>])

This example shows output for a ROUTING LIST command, where the existing rules are DefaultRouting, rejectRouting, managedRouting, and passiveRouting.

unityadmin>  ROUTING LIST; 
DefaultRouting REJECT LOGON
readSys1Only READ sys1
prefReadOnly READ PREFERRED
readSys1WriteAll READ sys1 WRITE sys1, sys2
MSIUser READ WRITE CREATE BALANCED ERRORLIST MsiErrorList
accessUpgrade READ WRITE OPTIONS ACCESS UPGRADE
prPref PASSIVE sys1, sys2
prLU PASSIVE ALLOW MANAGED WRITES LEAST USED sys1, sys2
prRR PASSIVE ROUND ROBIN sys1, sys2
prWRR PASSIVE ROUND ROBIN sys1, sys2 WEIGHTED 2,1