IBM Informix client/server connectivity information, the sqlhosts information, contains information that enables a client application to find and connect to any Informix database server on the network.
For a detailed description of the sqlhosts information, refer to The sqlhosts Information.
On UNIX, the sqlhosts file resides, by default, in the $INFORMIXDIR/etc directory. As an alternative, you can set the INFORMIXSQLHOSTS environment variable to the full pathname and filename of a file that contains the sqlhosts file information. Each computer that hosts a database server or a client must have an sqlhosts file.
Each entry (each line) in the sqlhosts file contains the sqlhosts information for one database server or coserver. Use white space (spaces, tabs, or both) to separate the fields. You cannot include any spaces or tabs within a field. To put comments in the sqlhosts file, start a line with the comment character (#). You can also leave lines completely blank for readability. Additional syntax rules for each of the fields are provided in the following sections, which describe the entries in the sqlhosts file. Use any standard text editor to enter information in the sqlhosts file.
Table 4 shows a sample sqlhosts file.
dbservername | nettype | hostname | servicename | options |
---|---|---|---|---|
menlo | onipcshm | valley | menlo | |
newyork | ontlitcp | hill | dynsrvr2 | s=2,b=5120 |
sales | ontlispx | knight | sales | k=0,r=0 |
payroll | onsoctcp | dewar | py1 | |
asia | group | - | - | e=asia.3 |
asia.1 | ontlitcp | node6 | svc8 | g=asia |
asia.2 | onsoctcp | node0 | svc1 | g=asia |