Converting a Simplex Server to Multiplex

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

Prerequisites

You have DBA authority (or Multiplex Admin and Backup and Space Admin authority).
The simplex server is running.
The simplex server’s SCC agent is registered, authenticated, and running.

Task

In the Perspective Resources view, select a simplex resource.
From the application menu bar, select View > Open > Administration Console.
In the left pane of the Administration Console, select either:
- IQ Servers
- IQ Servers > Multiplex Management > Multiplex Servers
Select the simplex from the right pane and either:
- Click the arrow to the right of the name and select Add Secondary Nodes, or
- From the Administration Console menu bar, select Resource > Add Secondary Nodes
Enter a name in the Multiplex Name field.

Cick Add and specify:

Area	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 Sybase Control Center agent.
SCC agent user	User ID for the Sybase Control Center agent.
SCC agent password	Password for the Sybase Control Center agent.
Public host/port pairs	Host/port pairs in the format host1:port2,host2:port2, and so on.
Private host/port pairs	Host/port pairs in the format host1:port2,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.

(Optional) Import server definitions from a CSV file.

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

Area	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 existing server definitions to a CSV file for safekeeping:
1. On the Node Definitions page of the wizard, click Export and specify:
  
  Area Description
  
  Field Delimiter The default field delimiter is a vertical bar "|". You can specify a different field delimiter.
2. Click OK.
Click Execute.
If Sybase Control Center continues to display the converted multiplex server as a simplex, reauthenticate the simplex resource to force SCC to update its display.