To create the database, Sybase Central must connect to a Sybase IQ server. This dialog prompts you for the server connection parameters, including the server name, host name, server port number, agent port number, user ID, and password.
After you define the connection parameters, click Next to move to the next dialog.
If you chose to start your database automatically or you indicated that an existing IQ server should be used to create the database, then the wizard provides a list of existing Connection Profiles. Alternately, you can supply a specific server name.
The best way to specify connection information is to
use a connection profile. For details, see Creating
connection profiles in System Administration Guide: Volume 1.
If there is a Connection Profile that you want to use, choose a profile from the drop-down. If there is no appropriate connection profile available, identify the server that you want to use in the Server Name field.
No matter what server creates the database, you need to specify the parameters in Table 4-1.
Parameter name |
Description |
|---|---|
Host Machine |
Name of the host system where the new database is created. |
Port Number |
Port number on which the server is listening. |
Agent Port |
Port number where the IQ Agent on the given host listens. The default Agent port number is 1099. If you do not know the port, leave it blank: when you move to the next page, the wizard attempts to find the IQ Agent for you. |
Username |
Name of any user with DBA authority.
The Username defaults to |
Password |
Password for the given user name. The
password for this user defaults to |
By default, all newly-created Sybase IQ databases use DBA and sql as user
ID and password combination. For security reasons, Sybase strongly recommends
that you change the DBA password from the default. Changing the
DBA password requires DBA authority.
If you chose not to start the database automatically, type the password for the DBA user and check that the host machine and port number are correct, then click Next.
If you start the database manually, and use an active server instead of the Utility Server, type the server name and port number for the active IQ server. If a connection profile exists for the server, you can choose the server from the Connection Profile dropdown menu.
