ROUTING LIST Command | unityadmin | Teradata Unity - ROUTING LIST - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.51
Published
May 2020
Language
English (United States)
Last Update
2020-06-01
dita:mapPath
oic1588030762460.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

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