sp_iqmpxcheckdqpconfig is a diagnostic tool that checks the DQP configuration for the current connection. If DQP fails, run sp_iqmpxcheckdqpconfig to determine if DQP configuration issues are causing the query distribution failure.
sp_iqmpxcheckdqpconfig
No special privileges are required to execute the procedure.
| Column Name | Description |
|---|---|
| DiagMsgID | Uniquely identifies a diagnostic message |
| Description | Diagnostic message describing the issue found with DQP configuration |
| DiagMsgID | Description |
|---|---|
| 0 | No issues found with DQP configuration |
| 1 | Database is a simplex |
| 2 | Multiplex is running in single-node configuration mode |
| 3 | Login policy option dqp_enabled is set to OFF |
| 4 | Temporary dqp_enabled connection option is set to OFF |
| 5 | Logical server context has only one member node |
| 6 | Coordinator does not participate in DQP since its named membership in the logical server is currently ineffective |
| 7 | Coordinator does not participate in DQP since its logical membership in the logical server is currently ineffective because ALLOW_COORDINATOR_AS_MEMBER option in Root Logical server policy set to OFF |
| 8 | There is no dbfile in IQ_SHARED_TEMP dbspace |
| 9 | All dbfiles in IQ_SHARED_TEMP dbspace are READ ONLY |
| 10 | IQ_SHARED_TEMP dbspace is dynamically offline |
Sample output from the sp_iqmpxcheckdqpconfig procedure:
diagmsgid description
3 Login policy option dqp_enabled is set to OFF
5 Logical server context has only one member node
6 Coordinator does not participate in DQP since its
named membership in the logical server is
currently ineffective
7 Coordinator does not participate in DQP since
its logical membership in the logical server
is currently ineffective because
ALLOW_COORDINATOR_AS_MEMBER option in Root
Logical server policy set to OFF
8 There is no dbfile in IQ_SHARED_TEMP dbspace