Server Names

Name a server by supplying a -n switch before the first database file. The rest of the parameters are added from the default.cfg file.

For example, this command starts a server named Cambridge_iqdemo and the iqdemo database on that server:

start_iq -n Cambridge_iqdemo iqdemo.db

Each server name must be unique across the local area network (domain). This prevents you from unintentionally connecting to the wrong server. The host name and port number combination does not uniquely identify the server. Appending a unique identifier to the server name is a useful convention. Assigning unique server names is especially important in a multiuser, networked environment where shared memory is used for local database connections. This convention ensures that all users can connect to the correct database, even when other databases with the same name have been started on other host systems.

To allow SAP Sybase IQ to locate the server regardless of the character set in use, include only seven-bit ASCII (lower page) characters in the server name.

Specifying a server name lets you start a database server with no database loaded. This command starts a server named Galt with no database loaded:

start_iq -n Galt -gm 10 -gp 4096

Note: Although you can start a server by relying on the default server name, it is a better practice to include both the server name and the database name, and to make the two names different. This approach helps users distinguish between the server and the databases running on it. You must specify the server name to start the server without starting a specific database.