Multiplex Planning Worksheet

Before creating a multiplex, check that the paths of proposed objects meet requirements.

Database paths on all platforms, whether raw device or operating system files, are limited to 128 bytes. SAP Sybase IQ supports:

Raw devices for IQ shared stores (IQ_SYSTEM_MAIN, IQ_SHARED_TEMP, and user dbspaces)
Both raw devices and operating system files for non-shared IQ stores (IQ_SYSTEM_TEMP)
Operating system files only for the catalog and transaction log

SQL statements for creating a multiplex require some or all of the following values.

Multiplex database requirements
Dialog item	Type/length	Notes
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.