Setting up the database server group registry key Windows™

The SQLHOSTS registry key fields must be set to during database server setup.

About this task

To set up the database server group registry key on Windows™:

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

    This value must correspond to the OPTIONS value in the database server name key.

  6. Select the key with the database server group name that you created 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, SERVICE).
  8. Add a value for the field.
    For a database server group, the SQLHOSTS registry key fields must have the following values:
    HOST       -
OPTIONS    i=unique_integer
PROTOCOL   group
SERVICE    -

    Each database server group must have an associated identifier (i) value that is unique among all database servers in your environment. Use dash (-) characters (ASCII 45) as null-field indicators for HOST and SERVICE to indicate that you are not assigning specific values to those fields.

  9. Repeat steps 7 and 8 for the remaining fields of the SQLHOSTS registry key.
  10. Select the database server group key and choose to add a key.
  11. Give the new key the name of the database server.

    This value must correspond to the database server key, whose OPTIONS value was set to the database server group key.

  12. If you are combining Enterprise Replication with HDR, create keys for primary and secondary HDR servers under the same database server group.