Show TOC

AFFINITY_AUTOEXCLUDE_TIMEOUT OptionLocate this document in the navigation structure

The amount of time before SAP 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.

Remarks

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