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:
  
  1. 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
     

     
     
  2. 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