The sqlhosts file and the SQLHOSTS registry key

IBM® Informix® client/server connectivity information, the sqlhosts information, contains information that enables a client application to find and connect to any IBM 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
Parent topic: Connectivity files
Related concepts:
Redirecting clients with the connectivity information
Related tasks:
Supporting multiplexed connections
Related reference:
Network protocol