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
SQLHOSTSserver group entries. To remedy this problem, pursue the following options:
- Create a separate
sqlhostsfile, e.g.,. (This second sqlhosts file cannot contain server group entries.) Then, set thesqlhosts2 INFORMIXSQLHOSTSenvironment 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
sqlhostsfile.
- Create a separate
- If you are using a Single-Tier driver, the
file (or the sqlhosts information in the Windows registry) should be checked, to confirm that all data therein is correct and contains supported values.$INFORMIXDIR/etc/sqlhosts
- If you are working with IBM Informix Dynamic Server, IBM Informix Universal Server, or IBM Informix OnLine Dynamic Server, also check the
DBSERVERNAME,DBSERVERALIASES, andNETTYPEparameters in the$ONCONFIGconfiguration file or within theinformixserverentries in the registry.
- If you are working with IBM Informix SE, check the
dbservername,nettype,hostname, andservicenamefields in thesqlhostsfile 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