Toad Data Studio 1.1 - Release Notes

Configure DB2 LDAP Support

You can create DB2 Lightweight Directory Access Protocol (LDAP) connections when the DB2 client installed with Toad is configured for LDAP. Configuring the client consists of enabling LDAP support and specifying the host name and port number of the LDAP server. Once the client is configured, Toad retrieves names from your LDAP server and displays them in the Database Alias list in the Connections window.

Notes:

• You must configure LDAP support for the DB2 client installed with Toad regardless of whether an existing DB2 client on the computer is already configured to support LDAP.

• Currently, Toad for DB2 supports only the access of DB2 LDAP catalog entries. Toad does not support the management of these entries.

To configure the DB2 client for LDAP

1. Open the Command Window for the DB2 client installed with Toad by selecting Start | All Programs | IBM DB2 | <ToadCom, ToadEval, or ToadFree> | Command Line Tools | Command Window.

2. Enter the following command to enable LDAP support:

   db2set DB2_ENABLE_LDAP=YES

3. Enter the following command to specify the TCP/IP host name and port number of the LDAP server:

   db2set DB2LDAPHOST=<hostname[:port]>

   The port number defaults to 389 (default LDAP port) if you leave the port number blank.  

4. Exit the Command window.

5. Launch Toad and open the Connections window.

   Databases on the LDAP server should be available from the Database alias drop-down list in the Connections window. To complete the Toad connection setup, you must create a Toad connection profile for each database. Create Toad Connection Profiles for DB2

Related Topics

Create DB2 Connections