MPX_AUTOEXCLUDE_TIMEOUT Option

Timeout for auto-excluding a secondary node on the coordinator node. 0 indicates that the nodes will not be auto-excluded. This option does not apply to the designated failover node.

Allowed Values

0 to 10080 minutes (1 week). Values must be exactly divisible by the MPX_HEARTBEAT_FREQUENCY setting in minutes. For example, if the MPX_HEARTBEAT_FREQUENCY setting is 120 (2 minutes), MPX_AUTOEXCLUDE_TIMEOUT must be divisible by 2.

Default

60 minutes

Scope

Can be set only for the PUBLIC group. Requires DBA permissions to set the option. Setting takes effect immediately and persists across server restarts.