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®
Informix® products,
but of your other applications.
To set up SQLHOSTS with regedit:
Procedure
- Run the Windows™ program, regedit.
- In the Registry Editor window, select the window for the HKEY_LOCAL_MACHINE subtree.
- Click the folder icons to select the \SOFTWARE\INFORMIX\ SQLHOSTS branch.
- With the SQLHOSTS key selected, add a key.
- Give the new key the name of the database server.
- Select the new key that you just made (the key with the database server name) and add a string value for it.
- 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.
- Modify the value to add value data.
- 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