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

Teradata® Business Continuity Manager User Guide
Product
Teradata Business Continuity Manager
Release Number
1.0
Published
January 2022
Language
English (United States)
Last Update
2022-01-27
dita:mapPath
otc1639627713801.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem
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 automatic failover of the standby system.
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.
  • If set to True, reads are included in the count.
  • If set to False, only outstanding writes are included in the count.
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.
  • If set to 1, Business Continuity Manager ignores any mismatch in the row counts.
  • If set to 0, Business Continuity Manager moves the tables to an Unrecoverable state.
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.