The sqlhosts file and the SQLHOSTS registry key

HCL Informix® client/server connectivity information, the sqlhosts information, contains information that enables a client application to find and connect to any HCL 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

Copyright© 2019 HCL Technologies Limited