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.
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. |
