sp_iqmpxexcludeserver procedure

Function

Routine to logically remove or include a query server for versioning purposes.

Syntax

sp_iqmpxexcludeserver( IN _server VARCHAR(30),
		IN _reqStat VARCHAR(10))

Description

Updates a query server's node_state column in IQ_MPX_INFO. If the status is already as expected, then does nothing. Drops or recreates SQL Remote subscriptions as needed.

**Table 9-36: sp_iqmpxexcludeserver arguments**
Argument	Description
_server	Server to modify
_reqStat	Server status. Set to 'include' to bring a query server back into the multiplex and set its node_status to 'ACTIVE', or 'exclude' to remove a query server from multiplex versioning and set its node_status to 'INACTIVE'. Updates SQL Remote configuration as necessary. If the node_status for the server is already in the requested state, does nothing.