The sqlhosts File on UNIX

On UNIX, the sqlhosts file contains connectivity information. The default location of this file is $INFORMIXDIR/etc/sqlhosts. If you store the information in another location, you must set the INFORMIXSQLHOSTS environment variable. For more information, see The sqlhosts File and the SQLHOSTS Registry Key.

If you set up several database servers to use distributed queries, use one of the following ways to store the sqlhosts information for all the databases:

• In one sqlhosts file, pointed to by INFORMIXSQLHOSTS
• In separate sqlhosts files in each database server directory

Use a text editor or ISA to edit the sqlhosts file. For more information, see Configuring Connectivity Using ISA.

Network-Configuration Files

In addition to the sqlhosts files, TCP/IP connections require entries in the /etc/hosts and /etc/services files. For IPX/SPX connections, the names of the auxiliary files depend on the hardware vendor.

Network-Security Files

IBM Informix database servers follow UNIX security requirements for making connections. Thus, the UNIX system administrator might need to make modifications to the /etc/passwd, etc/hosts, ~/.rhosts, and other related files.

The network-configuration and network-security files are described in operating-system manuals.