The sqlhosts information in the sqlhosts file on UNIX or the SQLHOSTS registry key on Windows contains connectivity information for each database server. The sqlhosts information also contains definitions for groups. The database server looks up the connectivity information when you start the database server, when a client application connects to a database server, or when a database server connects to another database server.
The connectivity information for each database server includes four fields of required information and one optional field. The group information contains information in only three of its fields.
The five fields of connectivity information form one line in the UNIX sqlhosts file. On Windows, the database server name is assigned to a key in the SQLHOSTS registry key, and the other fields are values of that key. The following table summarizes the fields used for the sqlhosts information.
| UNIX
Field Name |
Windows
Field Name |
Description of
Connectivity Information |
Description of
Group Information |
|---|---|---|---|
| dbservername | Database server name key or database server group key | Database server name | Database server group name |
| nettype | PROTOCOL | Connection type | The word group |
| hostname | HOST | Host computer for the database server | No information.
Use a hyphen as a placeholder in this field. |
| servicename | SERVICE | Alias for the port number | No information.
Use a hyphen as a placeholder in this field. |
| options | OPTIONS | Options that describe or limit the connection | Group options |
If you install IBM Informix Enterprise Gateway with DRDA in the same directory as the database server, your sqlhosts file also contains entries for the Gateway and non-Informix database servers. However, this manual covers only the entries for the database server. For information about other entries in the sqlhosts file, see the IBM Informix Enterprise Gateway with DRDA User Manual.