Setting Up the Database Server Group Registry Key

After you create the registry key for the database server, you must make a registry key for the database server group that includes the database server.

About this task

In this manual, each of the names of the database server groups are the database server names prefixed by g_. The g_ prefix is not a requirement; it is just the convention that this manual uses.

Procedure

To set up the database server group registry key
  1. With the SQLHOSTS key selected, choose to add a new key.
  2. 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.
  3. Select the key with the database server group name that you just created and add a new string value for it.
  4. Give the value the name of one of the fields of the sqlhosts information (HOST, OPTIONS, PROTOCOL, SERVICE).
  5. Add a value for the field.
    For a database server group, the sqlhosts information fields should have the following values: 
    HOST       -
OPTIONS    i=unique-integer-value
PROTOCOL   group
SERVICE    -

    Each database server group must have an associated identifier value (i=) that is unique among all database servers in your environment. Enter a minus (-) for HOST and SERVICE to indicate that you are not assigning specific values to those fields.

  6. Repeat steps 4 and 5 for the remaining fields of the sqlhosts
  7. Select the database server group key and choose to add a key.
  8. 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.
  9. If you are combining Enterprise Replication with HDR, create keys for primary and secondary HDR servers under the same database server group.
  10. Exit from the Registry Editor.

Results

For example, a database server group named g_iris could have a key under the SQLHOSTS key with the following values:

  • HOST: -
  • OPTIONS: i=5327
  • PROTOCOL: group
  • SERVICE: -
A key for the database server iris_112 would appear both directly under SQLHOSTS and under g_iris: 
SQLHOSTS
	iris_112
	g_iris
		iris_112