sp_iqmpxdropqueryserver procedure

Function

Drops a query server.

Syntax

sp_iqmpxdropqueryserver( IN l_server_name   VARCHAR(30))

Description

Procedure to drop a query server from the multiplex. Must run on write server. Must run while no other user is connected as DBA. Drops all of the server’s dbspaces and removes configuration information from system tables, IQ_MPX_INFO and IQ_MPX_STATUS.

Usage

l_server_name Name of the server to drop.