Solving Problems Using IBM Informix Products

The problems in this section relate to product usage.

• Problem. The list of databases is incomplete.

  Solution. Check that the DBPATH environment variable contains the names of all other database servers not referenced by the INFORMIXSERVER environment variable.

• Problem. After you access an IBM Informix application, the screen display is unformatted.

  Solution. Verify that the TERM, TERMCAP (or TERMINFO), and INFORMIXTERM environment variables are set correctly (see Configuring the Database Server).

• Problem. You successfully install your IBM Informix products and you successfully invoke the database server, but you cannot connect to the database server.

  Solution. Check that your environment variables and your sqlhosts, /etc/hosts, and /etc/services files do not contain typographical errors, misspellings, or inconsistencies.

  If you use a network information system, check that the changes you make to the services file are properly accessed and available to your computer.

  Check that the database server is configured correctly. See the chapter on client/server connectivity in the IBM Informix: Administrator's Guide.

• Problem. Unusual problems occur (for example, networking problems on Hewlett-Packard computers or unexplainable failures on Sun computers).

  Solution. Your system might need a patch. Read the machine notes file for advice on patch information. For more information, see Online Notes.