sp_iqmpxcreatequeryserver procedure

Function

Adds a query server.

Syntax

sp_iqmpxcreatequeryserver( IN l_host_name   VARCHAR(40),
		IN l_server_name VARCHAR(30),
		IN l_db_path     VARCHAR(1024),
		IN l_port_number 					VARCHAR(40))

Usage

Run only on write server.

Description

Updates IQ_MPX_INFO and IQ_MPX_STATUS, and sets up the new SQL Remote configuration for a new query server.

**Table 9-34: sp_iqmpxcreatequeryserver columns**
Column name	Description
l_host_name	Name of machine where query server will run
l_server_name	Server name for the query server to use
l_db_path	Full path to the query server’s catalog database (.db) file
l_port_number	TCP Port number the query server should listen on