Parameter | Default | Valid Values | Scope | Description |
---|---|---|---|---|
AccountStringScanFreq | 600 | 0 to infinity, inclusive | Frequency at which the user account strings are scanned on each Teradata system. | |
ActivateTimeout | 60 | 0 to infinity, inclusive | Time (in seconds) after which an activate operation fails if blocked by an active transaction. | |
AlertScriptsEnabled | False | True or False | Controls whether the script actions are enabled for alerts. | |
AutoConfig | 24 | 0 to infinity, inclusive | Interval (in hours) after which Business Continuity Manager automatically adjusts any configuration settings based on the workload statistics. Set to 0 to disable this feature. |
|
AutomaticStandbyFailover | 1 | 0 or 1 | Controls the failover mode.
|
|
AutoRestoreOnSyncFailure | 5 | 0 to 1000 | Number of times Business Continuity Manager allows the same synchronization failure before automatically synchronizing the complete repository from the active system to the standby system. Set to 0 to disable this feature. | |
AutoRestoreUnsyncedRepository | No | Yes or No | If set to Yes, the sequencer automatically resynchronizes an unsynchronized standby repository. | |
AutoResyncRetryWait | 900 | 1 to infinity, inclusive | Time (in seconds) before the sequencer resynchronizes an unsynchronized repository. | |
CatalogModResponseTimeout | 120 | 1 to infinity, inclusive | Time (in seconds) that the sequencer waits for a response from an endpoint/dispatcher for a catalog modification request before forcing the endpoint/dispatcher to reconnect to the mesh. | |
ChangedTableScanFreq | 30 | 0 to infinity, inclusive | Frequency (in minutes) at which the modified tables from DBQL are scanned on Teradata systems. | |
CheckpointAlertThreshold | 21600 | 0 to infinity, inclusive | Time (in seconds) after which an alert is raised when Business Continuity Manager is unable to obtain a recovery checkpoint. | |
CheckpointRetryInterval | 60 | 10 to 999999 | Interval (in seconds) after which the sequencer reattempts to perform a recovery checkpoint following a checkpoint timeout. | |
ClientSessionsThreshold | 0 | 0 to infinity, inclusive | Number of sessions at which Business Continuity Manager raises an alert to warn that the client load exceeds the environment limit. | |
DictionaryLoadThreads | 40 | 1 to infinity, inclusive | Number of threads used to load the data dictionary. | |
DictionaryMaxDDLConnections | 1 | 1 to 20000 | Number of repository database connections used to process DDL connections. | |
DictionaryReclaimWaitTime | 244800 | 0 to infinity, inclusive | Time (in seconds) before the objects marked for reclaim are reclaimed. | |
ElicitFilesCleanupFrequency | 300 | 0 to infinity, inclusive | Determines (in seconds) the frequency at which the elicit files are cleaned. | |
EnableIncludeReadsInLBQ | True | True or False | Determines whether only writes or
both reads and writes are included in the count of outstanding requests
in LBQ (managed) read load-balancing.
|
|
ExportMaxJobs | 5 | 0 to infinity, inclusive | Maximum number of export jobs supported on a Business Continuity Manager system. | |
IgnoreDeleteRowCountMismatch | 1 | 0 or 1 | Determines whether Business Continuity Manager ignores any mismatch in the row counts on DELETE
requests.
|
|
LoadMaxJobs | 0 | 0 to infinity, inclusive | Maximum number of simultaneous load jobs. If set to 0, this parameter is overridden by TASM. | |
LoadRequestTimeout | 90 | Value type: Integer Supported value range: greater than or equal to 5 |
Only for sequencer | Timeout length (in seconds) for a load request from the sequencer. Use to prevent timeouts for the load request from the active sequencer, for example, when the two Business Continuity Manager regions have significant network delays. |
ObjectRowLockEscalateThreshold | 10000 | 1 to 1000000 | Number of row locks a single object may take, after which the locks escalate to a table-level lock. | |
ObjectSortLimit | 5000 | 2 to infinity, inclusive | Number of objects the OBJECT LIST command can sort. | |
RecoveryCheckpointInterval | 10 | 0 to infinity, inclusive | Recovery Log size (in MB) exceeding which the sequencer performs a checkpoint. | |
RecoveryCheckpointTimeout | 10 | 0 to infinity, inclusive | Time (in seconds) after which Business Continuity Manager abandons the attempt to take a recovery checkpoint. | |
RecoveryInterval | 300 | 0 to infinity, inclusive | Interval (in seconds) at which the sequencer attempts to start recovery on an interrupted system or object. Set to 0to disable this feature. | |
RecoveryLogFullyCreate | False | True or False | If set to True, a recovery is fully allocated before the sequencer starts. | |
RecoveryLogGrowthAlertRate | 0 | 0 to infinity, inclusive | Recovery log (bytes) consumed by all sessions in the last 60 minutes. Set to 10% of the total recovery log size. | |
RecoveryLogGrowthSessionAlertRate | 0 | 0 to infinity, inclusive | Recovery log (bytes) consumed in the last 60 minutes. Set to 5% of the total recovery log size. | |
RecoveryLogGrowthSessionAlertThreshold | 0 | 0 | Recovery log (bytes) consumed by the lifetime of the session. Set to 2.5% of the recovery log size. | |
RecoveryLogGrowthSessionKillRate | Recovery Log (in bytes) consumed by the session in the last 60 minutes, exceeding which the session is forcefully terminated. Set to 5% of the Recovery Log size. | |||
RecoveryLogGrowthSessionKillThreshold | Total Recovery Log (in bytes) consumed by the lifetime of the session, exceeding which the session is forcefully terminated. Set to 5% of the Recovery Log size. | |||
RecoveryLogSize | 2 | 1 to 10000 | Recovery log size, in GB. | |
RecoveryLogSyncTimeout | 60 | 0 to 86400 | The amount of time the sequencer waits for completing the Recovery log sync requests. | |
RecoveryPreauthorizedLogin | 1 | 0 or 1 | Controls the use of proxy authentication during recovery. | |
RecoveryQueueLimit | 100000 | 1 to infinity, inclusive | Number of outstanding recovery requests supported for an active system before Business Continuity Manager moves the system to the Restore state. | |
RecoveryTimeout | 300 | 5 to infinity, inclusive | Time the sequencer waits for a response before timeout. Set this parameter longer than the average time taken by the load jobs. | |
RepoSyncedTxnPurgeInterval | 3600 | 0 to infinity, inclusive | Interval after which the repository synchronization requests are cleaned up. | |
SecondarySessionIdleTimeout | 60 | 0 to infinity, inclusive | Time (in seconds) the sequencer waits before forcefully stopping the secondary session using the SESSION KILL command. | |
SessionReconnectTimeout | 0 | 0 to 36000000 | Time for which Business Continuity Manager holds a session open for reconnecting if the session disconnects abruptly. | |
SetInterruptOnUnrecoverableCascade | False | True or False | Interrupts the target table,
preventing the table from becoming unrecoverable if a write request to
the table fails. This setting is suitable when running scheduled load jobs but not for online applications. |
|
SynchronousCatalogModBroadcast | True | True or False | If enabled, DDL changes are synchronized across all endpoints and dispatchers. With this setting, load jobs can span multiple endpoints and dispatchers. | |
SystemHaltTimeout | 1800 | 60 to infinity, inclusive | The amount of time the sequencer waits before moving the system from an Active state to an Out of Service or Read-Only state. | |
TableHaltTimeout | 300 | 1 to infinity, inclusive | The amount of time the sequencer waits before moving the table from an Active state to an Out of Service or Read-Only state. | |
TransactionRequestLimit | 20000 | 0 to infinity, inclusive | Number of requests supported within a single transaction. | |
TransactionRowLockEscalateThreshold | 10000 | 1 to 1000000 | Number of row locks a single transaction may take, after which the locks escalate to a table-level lock. | |
UseAlternateAccountStringView | False | True or False | If set to True, Business Continuity Manager collects the modified tables from the view tdbcmgmt. accountstrings_V. If set to False, Business Continuity Manager collects the modified tables using the default account string SQL. | |
UseAlternateChangedTableView | False | True or False | If set to True, Business Continuity Manager collects the modified tables from the view tdbcmgmt.changedtable_V. If set to False, Business Continuity Manager collects the modified tables directly using DBQL. |