| 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 make sure 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 make sure 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. |