The sqlhosts information

The sqlhosts information contains connectivity information for each database server and 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.

Each computer that hosts a database server or a client must include connectivity information.

In the sqlhosts file, each row contains the connectivity information for one database server, or the definition for one group.

In the registry, 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 that are used for the SQLHOSTS information.
Field name in the sqlhosts file Field name in the SQLHOSTS registry key 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 keyword group
hostname HOST Host computer for the database server No information. Use a dash as a placeholder in this field.
servicename SERVICE Alias for the port number No information. Use a dash as a placeholder in this field.
options OPTIONS Options that describe or limit the connection Group options
UNIX: If you install HCL 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 section 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.

Copyright© 2019 HCL Technologies Limited