Parameter | Default (Valid Values) |
Description |
---|---|---|
AutoSelfHealingInterval | 0 (0 to infinity) | This is the interval in seconds that the sequencer will attempt to validate, re-activate and resync any tables that have become unrecoverable due to data inconsistencies. (0 to disable). |
AutoSelfHealingOptions | 0 (0, 1) | This controls whether the self-healing loop will validate (0) or validate and resync (1). |
AutoSelfHealingThreads | 1 (1 to infinity) | This is the number of concurrent threads used to send table validation and resync requests in the self-healing loop. |
AutoTableValidateAttempts | 0 (-1 to infinity) | The number of times table validation will be attempted on a table unrecoverable due to data inconsistency. (-1 for unlimited, 0 to disable). |
CDMStreamSupportEnabled | true (true/false) |
When enabled and supported by the Teradata system, CDM Streaming protocol is used to extract and apply change data. This should only be disabled if a issue occurs when CDM Streaming is used. |
CDMMultiStreamSupportEnabled | true (true/false) |
When enabled and supported by the Teradata system, CDM Multi-Stream protocol is used to extract and apply change data. This should only be disabled if a issue occurs when CDM Multi-Stream is used. |
CDMSessionQueueLimit | 1000 (100 to infinity) |
The maximum amount (in MB) of queued change data information held in memory for a session before Unity starts throttling the read of incoming CDM data. |
CDMMaxDataConnectionsPerGroup | 25 1 to 1024 |
Specifies the maximum number of data connections to connect per replication group. |
DataFileAsyncNonBlockingWrite | true (true/false) |
By default, data files are distributed across regions asynchronously and limited by network capacity. When a data file size exceeds the network buffer, the write continues or pauses, based on the threshold setting in the DfsAsyncWriteMaxOutstandingMegaBytes parameter.
Only GSC configures this parameter.
|
DefaultObjectResyncOption | 1 (1, 2, 5) | This controls the default option for resyncing unrecoverable tables. (1 - Never resync, 2 – Resync the entire table, 5 – Resync periodically). The option on individual tables overrides this setting. |
DefaultObjectResyncTimeout | 300 (30 to infinity) |
This sets the default timeout (in seconds) for synchronizing tables using the table sync service. |
DefaultObjectValidationTimeout | 300 (30 to infinity) |
This sets the default timeout (in seconds) for validating tables using the table validation service. |
DfsAsyncWriteMaxOutstandingMegaBytes | 50 megabytes (1 to infinity) |
Maximum amount of outstanding DFS file data on a network buffer for asynchronous writes to a remote node. If reached, data files writes either pause (blocking mode) or continue (non-blocking mode), depending on the DataFileAsyncNonBlockingWrite setting. |
DirectSessionIdleTimeout | 0 (disabled) (0 to infinity) |
The number of seconds a direct session remains idle until Unity closes the matching Unity managed session. This feature is disabled by default because matching Unity managed session for direct sessions is automatically closed on logoff. This parameter is required to close Unity managed session for direct sessions for sessions from a connection pool. |
dynamicDFSIOTimeouts | 2 (0, 1, 2) |
Controls the behavior of read and write timeouts in DFS.
|
EnableActivityTrackingObfuscation | false (true/false) |
Prevents the collection of sensitive information in support bundles. The sensitive information includes SQL statements and IP addresses to be collected in log files, alerts, backtraces, core files, and so on. This value must be set to true for any of the other EnableActivityTrackingObfuscation* configuration values to take effect. |
EnableActivityTrackingObfuscationBacktraces | false (true/false) |
Prevents the collection of backtraces in support bundles. |
EnableActivityTrackingObfuscationCores | false (true/false) |
Prevents the collection of core files in support bundles. |
EnableActivityTrackingObfuscationIPAlerts | false (true/false) |
Prevents the collection of IP addresses in alerts. |
EnableActivityTrackingObfuscationIPLogs | false (true/false) |
Prevents the collection of IP addresses in log files. |
EnableActivityTrackingObfuscationSQLAlerts | false (true/false) |
Prevents the collection of SQL statements in alerts. |
EnableActivityTrackingObfuscationSQLLogs | false (true/false) |
Prevents the collection of SQL statements in log files. |
GatewayMonitorMinTimeout | 2 (Process Type or Per Process) |
Minimum period of time (in milliseconds) for the Monitor to start for each Gateway. If the Gateway does not respond, it is marked as down, and the timeout is adjusted by the value in GatewayMonitorTimeoutAdjust. |
GatewayMonitorTimeoutAdjust | 2 (Process Type or Per Process) |
Number of milliseconds the period of time allowed for the Gateway handshake increases. |
GatewayMonitorMaxTimeout | 3 (Process Type or Per Process) |
Maximum period of time (in milliseconds) allowed when attempting a handshake with the Gateway. |
GlobalDeadlockDetectionInterval | 0 (0, 10 seconds to infinity) |
The interval in seconds determines how often Unity detects a global deadlock between Unity and the Teradata database. Unity reads the session-level statistics from the Teradata database. The Teradata database updates its session-level statistics at an interval set by the session rate for the Teradata database. Accounting for both rates, the longest time to detect a deadlock between Unity and the Teradata database is the session rate for the database plus the time set in the GlobalDeadlockDetectionInterval. The default value 0 (zero) disables the setting. |
OperationPurgeTime | 168 hours | Sets the default expiration period in hours after which a completed operation can be purged. To purge operations immediately after they complete, set the expiration time to 0 (zero) hours. The last operation on a valid object, such as a table, or a system is not purged to ensure the persistence of a history for the object. |
PassiveRoutingFeature | Enabled* | Enables the passive routing feature. For installations of Unity15.10 or later, the parameter is enabled. To use the passive routing feature, set this parameter to enabled once the entire cluster has been upgraded to 15.10 or later. |
SetReadOnlyOnWriteFailure | false (true/false) | With the default value (true), when a recoverable transient error occurs on a request that reads and writes to multiple tables, all the tables being read from are placed in the Read-Only state. All the tables being written to are placed in the Interrupted state. If the feature is turned off (false), all the tables being written are placed in an Interrupted state, while the tables being read remain Active. |
ValidationUsername | dbc (*) | Database username used to validate tables. Must have the correct select permissions to read tables to validate their content. |
*For installations being upgraded from Unity 14.11, the parameter is set to disabled by default. |