Show TOC

CREATE MULTIPLEX SERVER StatementLocate this document in the navigation structure

Creates a multiplex server.

Syntax
CREATE MULTIPLEX SERVER <server-name> DATABASE 
   '<dbfile>' host-port-listROLE {  READER |  WRITER  } ] 
   [  STATUS | { INCLUDED |  EXCLUDED } ]
   [ { ENABLE | DISABLE }  RLV STORE ] 

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 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.
  • { ENABLE | DISABLE } RLV STORE allows the coordinator to use an in-memory store for high-performance row-level updates. Default if not specified is DISABLED.
  • 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.