The sqlhosts information in the sqlhosts file 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 initialize 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. The following table summarizes the fields used for the sqlhosts information.
| UNIX Field Name | Description of Connectivity Information | Description of Group Information |
|---|---|---|
| dbservername | Database server name | Database server group name |
| nettype | Connection type | The word group |
| hostname | Host computer for the database server | No information. Use a hyphen as a placeholder in this field. |
| servicename | Alias for the port number | No information. Use a hyphen as a placeholder in this field. |
| 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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]