sp_iqmakempx procedure

Function

Converts a database to a multiplex database, and converts the server to the write server for the multiplex.

Syntax

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

Description

Modifies IQ_MPX_INFO and IQ_MPX_STATUS and sets up the SQL Remote configuration for the write server.

Table 9-31: sp_iqmpx_makempx columns

Column name

Description

l_host_name

Name of machine where write server will run

l_server_name

Server name for the write server to use

l_db_path

Full path to the write server’s catalog database (.db) file

l_port_number

TCP port number the write server should listen on