Database Options

On a multiplex, database options control connections, distributed query processing and multiplex inter-node communications.

• DQP_ENABLED Option
  Temporary database option dqp_enabled allows you to enable or disable DQP at the connection level.
• 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.
• MPX_HEARTBEAT_FREQUENCY Option
  Interval until the heartbeat thread wakes and cleans up the connection pool on the secondary node.
• MPX_IDLE_CONNECTION_TIMEOUT Option
  Time after which an unused connection in the connection pool on a secondary node will be closed.
• MPX_MAX_CONNECTION_POOL_SIZE Option
  Maximum number of connections allowed in the connection pool on a secondary node.
• MPX_MAX_UNUSED_POOL_SIZE Option
  Maximum number of unused connections in the connection pool on a secondary node.
• MPX_WORK_UNIT_TIMEOUT Option
  Time, in seconds, before a multiplex DQP leader reassigns incomplete distributed work to another DQP worker node.