DBSERVERALIASES

onconfig.std
value

None

if not present

None

separators

Comma

range of values

Up to 128 lowercase characters for the coserver name. The value for DBSERVERALIASES must be unique, begin with a letter or underscore, and contain only letters, numbers, or underscores.

takes effect

When shared memory is initialized. In addition, you might need to update the sqlhosts file or registry of each database server.

refer to

The following topics in the chapter on client/server communications in the IBM Informix: Administrator's Guide:

• ONCONFIG parameters for connectivity
• Using multiple connection types

DBSERVERALIASES specifies a list of alternative dbservernames. If the database server supports more than one communication protocol (for example, both an IPC mechanism and the TCP network protocol), you must describe each valid connection to the database server with an entry in the sqlhosts file or registry. DBSERVERALIASES lets you assign multiple aliases to a database server, so each entry in the sqlhosts file or registry can have a unique name.

For each alternate name listed in DBSERVERALIASES, the database server starts an additional listener thread. If you have many client applications connecting to the database server, you can distribute the connection requests between several listener threads and reduce connection time. To take advantage of the alternate connections, instruct some of your client applications to use a CONNECT TO dbserveralias statement instead of CONNECT TO dbservername.

In Extended Parallel Server, clients specify a coserver name when they connect to a connection coserver. The DBSERVERALIASES parameter is part of this coserver name, which has the following format:

dbservername.coserver-number

In the name, dbservername is the same value that you assign to the DBSERVERALIASES configuration parameter when you specify more than one communication protocol in the ONCONFIG configuration file. And coserver-number is the same value that you assign to the COSERVER configuration parameter for the connection coserver.