AFFINITY_AUTOEXCLUDE_TIMEOUT Option

The amount of time before SAP Sybase IQ removes a shut down node from the affinity map and reassigns its partitions to other nodes.

Allowed Values

0 to 10080 minutes (1 week)

Default

10 minutes

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

Description

The amount of time before SAP Sybase IQ removes a shut down node from the affinity map and reassigns its partitions to other nodes.