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 Requires one of:
  • DBA authority.
  • All of these authorities:
    • MULTIPLEX ADMIN authority.
    • SPACE ADMIN authority.
    • BACKUP authority.
SAP Sybase IQ 16.0 Requires all of:
  • SERVER OPERATOR system privilege.
  • MANAGE MULTIPLEX system privilege.
  • MANAGE ANY DBSPACE system privilege.
  • BACKUP DATABASE system privilege.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Multiplex Management > Multiplex Servers.
  3. Select a multiplex 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.
  4. 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 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: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.
  5. Click OK.
  6. (Optional) Import server definitions from a CSV file:
    1. 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.
    2. Click OK.
  7. (Optional) Export your existing server definitions to a CSV file for safekeeping.
    1. On the Server Definitions page of the wizard, click Export and specify:
      Option Description
      Field Delimiter The default field delimiter is a vertical bar "|". You can specify a different field delimiter.
    2. Click OK.
  8. Click Next.
  9. On the Execution page of the wizard, click Execute.
Parent topic: Administer Multiplex Servers
Related concepts
Failover
Related tasks
Editing the Multiplex Server Configuration File
Starting a Multiplex Server
Stopping a Multiplex Server
Including an Excluded Secondary Server
Excluding a Secondary Server
Synchronizing a Secondary Server
Dropping a Secondary Server
Generating Administration Scripts for Multiplex Nodes
Converting a Simplex Server to Multiplex
Reconfiguring a Multiplex Server
Viewing or Modifying Multiplex Server Properties
Registering and Authenticating a Sybase Control Center Agent
Authenticating a Login Account for a Managed Resource
Related reference
Multiplex Privilege Summary