DISPATCHER Configuration Parameters - 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
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
Parameter Default Valid Values Scope Description
DatabaseConnectionTimeout 120 30 to 1200 Process Type or Per Process

Period of time (in seconds) allowed to pass before the Dispatcher process detects a lost Gateway connection. The minimum value you can set is 30 seconds. The maximum value is 1200 seconds.

DispatcherWorkpoolSizeMax null   Process Type or Per Process

Maximum number of worker threads in the Dispatcher worker pool. If the value is undefined (null) or less than the DispatcherWorkpoolSizeMin value, the Dispatcher uses the DispatcherWorkpoolSizeMin value or a multiple of five times the total number of CPU cores, whichever is greater.

DispatcherWorkpoolSizeMin 5   Process Type or Per Process

Minimum number of worker threads in the Dispatcher worker pool. The Dispatcher uses multiple threads in a worker pool to process SQL statements from the Unity server and forwards them to the Teradata Database system. The Dispatcher automatically adjusts the size of the worker pool based on the current number of sessions and the transaction rate.

ManagementPassword No default   Process Type or Per Process

ManagementUserid password.

ManagementUserid No default   Process Type or Per Process

Identifier for the Unity server user. This is the name of the Teradata user through which the Dispatcher and Sequencer processes connect to the Teradata Database system. The userid must be configured for TD2 authentication, and be able to read Unity Data Dictionaries and to create database tables.

MonitorDbConfigInterval 3600 300 to infinity   The interval in seconds at which the database settings (specifically HashFuncDBC and FixSRandomRange) are checked by the dispatcher. To disable the monitor, use the MonitorHashFuncDBC and MonitorFixSRandomRange parameters.
MonitorFixSRandomRange True True or False   Monitor control. This allows you to ensure the value of FixSRandomRange is consistent across the managed Teradata Database systems and Unity. If the value of FixSRandomRange is different, an alert is raised.
MonitorHashFuncDBC True True or False   Monitor control. This allows you to ensure the value of HashFuncDBC is consistent across the managed Teradata Database systems and Unity. If the value of HashFuncDBC is different, an alert is raised.
MonitorInterval 30   Process Type or Per Process

Period of time (in seconds) that the Dispatcher process takes to connect to each IP address and perform a configuration handshake which determines the availability of the IP address and the Gateway.

MonitorSystemSerialNumber True True or False   Monitor control. This feature creates and assigns serial numbers to the Unity-managed systems, so that Unity can verify that system gateway addresses are pointing to the correct system. The verification happens periodically as well as on system activation and recovery.
MonitorSystemSerialNumberInterval 1800 300 to infinity   The interval in seconds at which the system serial number will be periodically checked by the dispatcher. To disable the monitor, use the MonitorSystemSerialNumber parameter.
PrecedingMessageWaitTimeout 30 5 to infinity Process Type Period of time (in seconds) the Dispatcher waits for a preceding lock information message for a specific Endpoint request. On timeout, if a request is missing the preceding message, the request fails with: 4533 - Timeout waiting for preceding message. Please resubmit the request.
TDMSTPort 1025   Process Type or Per Process

Port number on which the Dispatcher connects to the Teradata Database system.

Tdpid No default   Process Type or Process

TDPID of the Teradata Database system managed by Unity that allows the Dispatcher to connect to the system. In a high-availability configuration, you must assign two Dispatchers the same TDPID value, one to each Region in the configuration.