Adding a Secondary Server

Add a secondary server to the multiplex server.

Prerequisites

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority All of these authorities: MULTIPLEX ADMIN authority SPACE ADMIN authority BACKUP authority
SAP Sybase IQ 16.0	You must have all of these: SERVER OPERATOR system privilege MANAGE MULTIPLEX system privilege MANAGE ANY DBSPACE system privilege BACKUP DATABASE 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, expand IQ Servers > Multiplex Management, and then select Multiplex Servers.
Select an IQ server from the right pane and either:
- Click the arrow to the right of the name and select Add Secondary Server, or
- From the Administration Console menu bar, select Resource > Add Secondary Server
The Add Secondary Servers wizard appears.

On the Server Definitions page, 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 new secondary server appears on the server list.