%META:TOPICPARENT{name="ErrorMessagesI"}%
=Invalid SQLHOSTS=
* When using Multi-Tier drivers, "invalid sqlhosts" errors may indicate that your Database Agent was built against a version of Informix which did not support SQLHOSTS
server group entries. To remedy this problem, pursue the following options:
## Create a separate sqlhosts
file, e.g., sqlhosts2
. (This second sqlhosts file cannot contain server group entries.) Then, set the INFORMIXSQLHOSTS
environment variable to point to this new file. For example:
{{{
export INFORMIXSQLHOSTS=/dbs/informix/32bit/7.3/etc/sqlhosts2
}}}
## Relink your database agent. This may enable your agent to work with the existing sqlhosts
file.
* If you are using a Single-Tier driver, the $INFORMIXDIR/etc/sqlhosts
file (or the sqlhosts information in the Windows registry) should be checked, to confirm that all data therein is correct and contains supported values.
* If you are working with IBM Informix Dynamic Server, IBM Informix Universal Server, or IBM Informix OnLine Dynamic Server, also check the DBSERVERNAME
, DBSERVERALIASES
, and NETTYPE
parameters in the $ONCONFIG
configuration file or within the informixserver
entries in the registry.
* If you are working with IBM Informix SE, check the dbservername
, nettype
, hostname
, and servicename
fields in the sqlhosts
file to make sure that you have entered the correct values.
* For additional information, refer to your Informix Administrator's Guide.
===Evidence===
* Database Agent Version String
* DBMS Version