Temporary database option DQP_ENABLED_OVER_NETWORK allows you to enable or disable distributed query processing over the network at the connection level.
ON, OFF
OFF
Requires the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for other user or role.
Can be set temporary for an individual or public.
LS Policy Option Setting | Database Option Setting | DQP Query Behavior |
---|---|---|
DQP_ENABLED 1 | DQP_ENABLED_OVER_NETWORK ON | Queries on the current connection execute over network. Other queries use the shared temporary store. |
DQP_ENABLED 2 | DQP_ENABLED_OVER_NETWORK ON | All queries execute over network |
DQP_ENABLED 2 | DQP_ENABLED OFF | All queries run in simplex mode. |