Preparing connectivity files

Prepare the files that the database server uses to communicate with client applications and with other database servers.

About this task

The connectivity information allows a client application to connect to any HCL® OneDB® database server on the network. The connectivity data for a particular database server includes the database server name, the type of connection that a client can use to connect to it, the host name of the computer or node on which the database server runs, and the service name by which it is known.

You must prepare the connectivity information even if the client application and the database server are on the same computer or node. You are not required to specify all possible network connections in the sqlhosts file before you start the database server. However, after you add connectivity information to the sqlhosts file, you must restart the database server to make the new connection available.

Procedure

To add connectivity information:
  1. Edit the sqlhosts file to include the correct connectivity information with a text editor or equivalent tool.
    • The default name and location of this file is $ONEDB_HOME/etc/sqlhosts (UNIX, Linux) or %ONEDB_HOME%\etc\sqlhosts (Windows).
    • If you set up several database servers to use distributed queries, use either one sqlhosts file to which the ONEDB_ SQLHOSTS environment variable points or separate sqlhosts files in each database server directory.
  2. If your system uses Internet Protocol network connections, enter settings in the following files:
    • UNIX, Linux: The /etc/hosts and /etc/services files.
    • Windows: The %windir%\system32\drivers\etc\services file.