Database Options

On a multiplex, database options control connections, distributed query processing and multiplex internode communications.

• DQP_ENABLED Option
  Temporary database option DQP_ENABLED allows you to enable or disable distributed query processing at the connection level.
• DQP_ENABLED_OVER_NETWORK Option
  Temporary database option DQP_ENABLED_OVER_NETWORK allows you to enable or disable distributed query processing over the network at the connection level.
• MPX_AUTOEXCLUDE_TIMEOUT Option
  Timeout for autoexcluding a secondary node on the coordinator node. This option does not apply to the designated failover node.
• MPX_HEARTBEAT_FREQUENCY Option
  Interval until the heartbeat thread wakes and performs periodic operations, such as checking for coordinator connectivity and cleaning up the connection pool on the secondary node. The heartbeat thread maintains a dedicated internal connection from secondary server to coordinator.
• MPX_IDLE_CONNECTION_TIMEOUT Option
  Time after which an unused connection in the connection pool on a secondary node will be closed.
• MPX_LIVENESS_TIMEOUT Option
  Time, in seconds, before a heartbeat on a secondary server declares the coordinator offline if the heartbeat fails to reconnect to the coordinator after the first disconnect. This option also determines how long the coordinator keeps a global transaction in a suspended state.
• 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.