Global Configuration Parameters | Teradata Business Continuity Manager - Global Configuration Parameters - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 1.01.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
1.01.01
Published
March 2023
Language
English (United States)
Last Update
2023-03-13
dita:mapPath
qra1653979755546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem
Parameter Default

(Valid Values)

Description
AutoSelfHealingInterval 0 (0 to infinity) The interval in seconds that the sequencer attempts to validate, re-activate, and resync any tables that have become unrecoverable due to data inconsistencies. (0 to disable).
AutoSelfHealingOptions 0 (0 or 1) Controls whether the self-healing loop performs validate (0) or validate and resync (1).
AutoSelfHealingThreads 1 (1 to infinity) 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 is attempted on a table that has become unrecoverable due to data inconsistency. (-1 for unlimited, 0 to disable).
CDMStreamSupportEnabled True (True or False) When enabled and supported by the Teradata system, CDM Streaming protocol is used to extract and apply change data. The parameter should only be disabled if an issue occurs when CDM Streaming is used.
CDMMultiStreamSupportEnabled True (True or False) When enabled and supported by the Teradata system, CDM Multi-Stream protocol is used to extract and apply change data. The parameter 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 Business Continuity Manager 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 or 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.
  • Set to false, data file writes pause if the outstanding data on a network buffer to a remote node exceeds the threshold. The data writes continue after the outstanding data is consumed and is under the threshold.
  • Set to true, data file writes continue when the amount of outstanding data on the network buffer to a remote node exceeds the threshold. Data writes proceed as fast as the local disk can write. Business Continuity Manager DFS reads the unsent data from the local file copies and sends the data to a remote node after the data is within the threshold.
Only GSC configures this parameter.
DefaultObjectResyncOption 1 (1, 2, or 5) 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) Sets the default timeout (in seconds) for synchronizing tables using the table sync service.
DefaultObjectValidationTimeout 300 (30 to infinity) 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 Business Continuity Manager closes the matching Business Continuity Manager managed session. This feature is disabled by default because matching Business Continuity Manager managed session for direct sessions is automatically closed on logoff. This parameter is required to close Business Continuity Manager managed session for direct sessions for sessions from a connection pool.
dynamicDFSIOTimeouts 2 (0, 1, or 2) Controls the behavior of read and write timeouts in DFS.
  • 0: Feature is disabled
  • 1: Feature is enabled for both read and write timeouts in DFS. A DFS read monitors the size of the file and does not timeout if data continues to be written to the file. DFS writes take into account the validity of the file and remote socket when doing writes and waiting for responses.
  • 2: Recommended setting. In addition to the parameters for setting 1, setting 2 allows reads to not timeout because of outstanding writes.
EnableActivityTrackingObfuscation False (True or 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 or False) Prevents the collection of backtraces in support bundles.
EnableActivityTrackingObfuscationCores False (True or False) Prevents the collection of core files in support bundles.
EnableActivityTrackingObfuscationIPAlerts False (True or False) Prevents the collection of IP addresses in alerts.
EnableActivityTrackingObfuscationIPLogs False (True or False) Prevents the collection of IP addresses in log files.
EnableActivityTrackingObfuscationSQLAlerts False (True or False) Prevents the collection of SQL statements in alerts.
EnableActivityTrackingObfuscationSQLLogs False (True or 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) The increment size (in milliseconds) used to adjust the gateway monitor timeout automatically. Business Continuity Manager automatically adjusts the timeout value used within GatewayMonitorMinTimeout and GatewayMonitorMaxTimeout, based on current gateway response times.
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 Business Continuity Manager detects a global deadlock between Business Continuity Manager and the database. Business Continuity Manager reads the session-level statistics from the database. The database updates its session-level statistics at an interval set by the session rate for the database. Accounting for both rates, the longest time to detect a deadlock between Business Continuity Manager and the 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 make sure the persistence of a history for the object.

PassiveRoutingFeature Enabled Enables the passive routing feature.
SetReadOnlyOnWriteFailure False (True or 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.
StandbySystemFailoverWaitTime 0 (0 to infinity) The wait time in seconds before Business Continuity Manager initiates automatic or manual failover to the standby systems.
ValidationUsername dbc Database username used to validate tables. Must have the correct select permissions to read tables to validate their content.