Multiplex planning worksheet

Sybase Central dialogs and SQL statements for creating a multiplex require some or all of the values in Table 2-1. Database paths on all platforms, whether raw device or operating system files, are limited to128 bytes.

Table 2-1: Multiplex database requirements

Dialog item

Type/length

Notes

Value

Host name

CHAR 128

Name of the machine where the database engine will run.

Server name

CHAR 128

Server name for the coordinator. (The server name must be unique across the local area network.)

Database path

CHAR 128

Create the database files on a local disk, not a remote location.

The Create Database wizard asks for the path to the dbfile. Users cannot specify where the server will be started.

IQ store paths (temp and main)

CHAR 128

All files in IQ_SYSTEM_MAIN and shared user dbspaces must be accessible in exactly the same way using the same file paths from all nodes. IQ main dbspace paths are shared and temporary and .iqmsg dbspace paths are only valid on the owning node.

Database name

CHAR 70

Database name, limited to 70 characters. Included in the path.