CREATE MULTIPLEX SERVER server-name DATABASE 'dbfile
' host-port list [ ROLE { READER | WRITER } ] [ STATUS | {
INCLUDED | EXCLUDED } ]
host-port-list:{ HOST ' hostname' PORT port-number }
Choose the name of the multiplex server (server-name) according to the rules for server startup option -n. See “Starting the database server” in Chapter 1, “Running the Database Server,” in the Utility Guide.
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.
The SYS.ISYSIQMPXSERVER system table stores the HOST hostname PORT portname pairs in its connection_info string as host:port[;host:port…].
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. The default ROLE is READER. The default STATUS is INCLUDED.
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.
For examples, see “Adding multiplex servers”.
Must have DBA or MULTIPLEX ADMIN authority.
