Multiplex Servers (IQ)

Sybase IQ v15.0 and higher supports multiplex, a highly scalable shared disk grid technology that allows concurrent data loads and queries via independent data processing nodes connected to a shared data source.

PowerDesigner models multiplex servers as extended objects with a stereotype of <<MultiplexServer>>.

Creating a Multiplex Server

You can create a multiplex server in any of the following ways:

  • Select Model > Multiplex Servers to access the List of Multiplex Servers, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select New > Multiplex Server.

Multiplex Server Properties

You can modify an object's properties from its property sheet. To open a multiplex server property sheet, double-click its Browser entry in the Multiplex Servers folder.

The following extended attributes are available on the Sybase tab:

Name

Description

Database

Specifies the database file with which the server is associated.

Scripting name: Database

Host port list

Specifies the machine where the database engine will run.

Scripting name: HostPortList

Role

Specifies the server's role in the multiplex environment.

Scripting name: Role

Status

Specifies whether the server is included or excluded. If a multiplex secondary server will be shut down for an extended period of time, that server should be excluded. Excluding the server allows the coordinator to ignore this server when performing version cleanup.

Scripting name: Status

Failover

Specifies that the server is a failover server.

Scripting name: Failover