Utilities to Update the LDAP Server with sqlhosts Data

The SqlhUpload and SqlhDelete utilities are packaged in ifxtools.jar, so the CLASSPATH variable must point to ifxtools.jar (which, by default, is in the lib directory under the installation directory for IBM Informix JDBC Driver). Make sure that the CLASSPATH variable also points to the JNDI JAR files and LDAP SPI JAR files.

SqlhUpload

This utility loads the sqlhosts entries from a flat ASCII file to the LDAP server in the prescribed format. Enter the following command:

java SqlhUpload sqlhfile.txt host-name:port-number [sqlhostsRdn]

The parameters have the following meanings:

• The sqlhosts file to be uploaded is sqlhfile.txt.
• The host name and port number of the LDAP server is host-name:port-number.
• The RDN (relative distinguished name) of the sqlhosts node under the Informix base in LDAP is sqlhostsRdn. The default name is sqlhosts.

The utility prompts for other required information, such as the Informix base DN (distinguished name) in the LDAP server, the LDAP user, and the password.

You must convert the servicename field in the sqlhosts file to a string that represents an integer (the port number), because the Java.Socket class cannot accept an alphanumeric servicename value for the port number. For more information about the servicename field, see the IBM Informix: Administrator's Guide for your database server.

SqlhDelete

This utility deletes the sqlhosts entries from the LDAP server. Enter the following command:

java SqlhDelete host-name:port-number [sqlhostsRdn]

The parameters of this command have the same meanings as the parameters listed for SqlhUpload on page ***.

The utility prompts for other required information, such as the Informix base DN in the LDAP server, the LDAP user, and the password.