The sqlhosts file and the SQLHOSTS registry key

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.

The default location of the sqlhosts file is:

UNIX:
$INFORMIXDIR/etc/sqlhosts
Windows:
%INFORMIXDIR%\etc\sqlhosts.%INFORMIXSERVER%

If you store the information in another location, you must set the INFORMIXSQLHOSTS environment variable.

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 the INFORMIXSQLHOSTS environment variable
  • In separate sqlhosts files in each database server directory