Converting a Simplex Server to Multiplex

Add a secondary server to a simplex to convert the simplex into a multiplex.

Prerequisites

Database Version	Simplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority MULTIPLEX ADMIN authority
SAP Sybase IQ 16.0	You must have MANAGE MULTIPLEX system privilege.

The SAP Sybase IQ resource is authenticated and running.
The multiplex server’s SCC agent is registered, authenticated, and running.
You must be licensed for the Multiplex Grid option (IQ_MPXNODE), if you are running secondary servers.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane of the Administration Console, select IQ Servers.
Select the IQ server simplex to be converted from the right pane and either:
- Click the arrow to the right of the name and select Add Secondary Servers, or
- From the Administration Console menu bar, select Resource > Add Secondary Servers
The Add Secondary Servers wizard appears.
On the Server Definitions page, enter a name in the Multiplex Name field.

Click Add and specify:

Option	Description
Server name	Secondary server name.
Host	The host name and port number for the new secondary server.
Database path	The path to the database file.
SCC agent port	Port number for the SAP Control Center agent.
SCC agent user	User ID for the SAP Control Center agent.
SCC agent password	Password for the SAP Control Center agent.
Public host/port pairs	Host/port pairs in the format host1:port1,host2:port2, and so on.
Private host/port pairs	Host/port pairs in the format host1:port1,host2:port2, and so on.
Role	Reader or writer.
Status	Included or excluded.
Local temp dbspace path	Temporary store path.
Local temp dbspace size (MB)	Size, in megabytes, of the temporary IQ store. 0 if you select a raw device.
Local temp dbspace reserve (MB)	The amount of space, in megabytes, to reserve for future expansion in the temporary IQ store.
Raw device	Indicates a raw disk.

Click OK.
The server definition appears on the list and the definition is validated. If the defintion contains any errorr, a red "X" appears. To determine the cause of the errors, position the mouse over the red "X." Details of the error appear. To correct the errors, select the definition and click Edit. Correct the errors and click OK; the definition is revalidated. When the definiton is error free, a green checkmark appears and the Next button becomes available.

(Optional) Import server definitions from a CSV file.

On the Server Definitions page of the wizard, click Import and specify:

Option	Description
File Name	File name of the CSV file containing delimited list of server definitions.
Browse	Opens a window where you locate the CSV file.
Field Delimiter	The default field delimiter is a vertical bar "\|". If your CSV file uses a different field delimiter, enter it in this field.

(Optional) Export your server definitions to a CSV file for safekeeping.
1. On the Server Definitions page of the wizard, highlight one or more definitions and click Export.
2. Specify a field delimiter and click OK. The default field delimiter is a vertical bar "|".
Click Next.
On the Execution page of the wizard, click Execute.
Progress messages appear in the Messages area. The Close button becomes available when the process is complete.
Click Close.
The multiplex replaces the simplex in the IQ Servers list in the Administration Console.
Note: If SAP Control Center continues to display the converted multiplex server as a simplex, close the Administration Console and re-authenticate the simplex resource in the perspective view to refresh the display.