DB2 LDAP connections

Use the New Database Connection wizard or pages that are embedded in other wizards to create a JDBC connection to DB2® servers that uses Lightweight Directory Access Protocol (LDAP). The workbench supports using Windows Active Directory containing DB2 schema extensions. This feature is not available in some products.

Before you can connect using this security option, you must extend the schema of the Active Directory server to support DB2 objects. See the DB2 information center for detailed information about completing this step.

You can use the IBM® Data Server Driver for JDBC and SQLJ to create connections to DB2 servers using LDAP. To create LDAP connections, select "IBM Data Server Driver for JDBC and SQLJ using LDAP" in the JDBC driver field of the New Connection wizard. LDAP is used to retrieve the host name and port number only.

To improve performance, specify a base distinguished name (DN) on the Driver Options section of the Connection Parameters page. If the base DN is not specified, then the entire LDAP hierarchy is searched, which can cause performance problems.


Feedback