CREATE MULTIPLEX SERVER Statement

Quick Links:

Syntax

CREATE MULTIPLEX SERVER server-name DATABASE 
   'dbfile' host-port-list [ ROLE {  READER |  WRITER  } ] 
   [  STATUS | { INCLUDED |  EXCLUDED } ]

host-port-list
   {[ PRIVATE ] HOST ' hostname ' PORT port number }

Parameters

(back to top)

PRIVATE – specifies that the particular HOST PORT pair is for private interconnection. A separate private interconnection for multiplex interprocess communication (MIPC) enables highly available and high-performance network configurations. SAP Sybase IQ automatically opens private ports; you need not list them in the host-port-list used to start the server. All public and private ports require unique port numbers to avoid conflicts.

server-name – the name of the multiplex server based on the rules for server startup option -n.

ROLE – default if not specified is READER.

STATUS – default if not specified is INCLUDED.

Applies to

Multiplex only.

Usage

(back to top)

If you plan to use UNIX soft (symbolic) links for server paths, create the soft link before you run CREATE MULTIPLEX SERVER. When you start the new server, the database file path must match the database file path specified when creating that server.

When creating the initial multiplex server, both coordinator node and secondary node rows are added to SYS.ISYSIQMPXSERVER. The transaction log records this operation as two separate CREATE MULTIPLEX SERVER commands, one for the coordinator node and one for the secondary node.

After creating the first secondary node, the coordinator shuts down automatically.

The SYS.ISYSIQMPXSERVER system table stores the HOST hostname PORT portname pairs in its connection_info string as host:port[;host:port…].

Note: Use multiple host:port pairs if the computer the multiplex server is running on has multiple redundant network cards mapped to different network addresses.

You may specify the clauses DATABASE, host-port list, ROLE and STATUS in any order.

When you add a server, the coordinator must be running, but you can run the CREATE MULTIPLEX SERVER command from any server in the multiplex.

This statement is automatically committed.

Permissions

(back to top)

Requires the MANAGE MULTIPLEX system privilege.