Setting up the SQLHOSTS Registry Key for Database Server with regedit

You can set the SQLHOSTS registry key with the regedit utility.

About this task

It is recommended that you use ISA to set up the SQLHOSTS registry key.

Important: Use extreme caution with regedit. If you make mistakes when editing the registry, you can damage the configurations, not only of your HCL® OneDB® products, but of your other applications.

To set up SQLHOSTS with regedit:

Procedure

  1. Run the Windows™ program, regedit.
  2. In the Registry Editor window, select the window for the HKEY_LOCAL_MACHINE subtree.
  3. Click the folder icons to select the \SOFTWARE\INFORMIX\ SQLHOSTS branch.
  4. With the SQLHOSTS key selected, add a key.
  5. Give the new key the name of the database server.
  6. Select the new key that you just made (the key with the database server name) and add a string value for it.
  7. Give the value the name of one of the fields of the sqlhosts information (HOST, OPTIONS, PROTOCOL, or SERVICE).
    Give the OPTIONS field the value of the database server group to which this database server belongs.
  8. Modify the value to add value data.
  9. Repeat steps 6 through 8 for each field of the sqlhosts information.

Results

For example, a database server named iris_112 might have a key under the SQLHOSTS key with the following values:

  • HOST: iris
  • OPTIONS: g=g_iris
  • PROTOCOL: onsoctcp
  • SERVICE: techpubs27