The Server Creation wizard derives some default field values from the single server you are converting. Refer to these sample conversion values for the Quick Start.
The Node Configuration dialog sets the multiplex node configuration properties.
| Field Name | Description | |
|---|---|---|
| Multiplex Server Name | The wizard derives the default value for this field from the name of the single server you are converting: <localhost>_iqdemo Change to: <localhost>_iqdemo_mpx |
|
| Server Name | This is the name of the first secondary server in your multiplex. This value must be different from server you are converting, which becomes the coordinator server for the multiplex. Use this value: <localhost>_iqdemo_w1 |
|
| Host Information | For the Quick Start, use the default Host Name and Port Number provided by the wizard. Using these values lets you set up the multiplex with multiple servers on the same host. |
|
| Agent | For the Quick Start use these values to bind the multiplex to the Sybase IQ Agent: |
|
| Port | 1099 (default) |
|
| Username | DBA (case-insensitive) |
|
| Password | sql (case-sensitive) |
|
| Mode | Change from Reader to Writer. You will use this node later to load data. |
|
| Create administrative shell scripts. | Generates scripts for starting, stopping, and synchronizing servers. | |
Database Path dialog sets an absolute path to database stores. The <pathname> placeholder refers to the path. When you see this placeholder, substitute the full path name.
| Field | Description |
|---|---|
| Database Path |
For the Quick Start, use the <pathname>\MyIQDemo\w1 subdirectory and identify the secondary server database file as iqdemo_w1.db. Although you can browse to the path, you must enter the database file name (iqdemo_w1.db). The full field value should read: <pathname>\MyIQDemo\w1\iqdemo_w1.db |
| Coordinator’s configuration options | Select the Use Coordinator’s configuration options to copy the params.cfg options for the existing database to the new multiplex server’s database directory. |
Temporary Dbspace Configuration dialog sets the path to the temporary dbspace file. As in the previous section, substitute the full path for the <pathname> placeholder.
| Field | Description |
|---|---|
| Temporary dbspace file path |
For the Quick Start, set the path to <pathname>\MyIQDemo\w1\iqdemo_w1.iqtmp. Although you can browse to the path, you must enter the database file name (iqdemo_w1.iqtmp). The full field value should read: <pathname>\MyIQDemo\w1\iqdemo_w1.iqtmp |
| RAW device option | Unselect the This is a RAW device option to display the default File size and Reserve size values. For the Quick Start, do not change these values. |
Review the conversion values.