Database connections

You can improve the performance of a directory server by increasing the DB2® connections. The performance improvement also depends on the server load and the nature of connections.

The default number of connections that are created between a directory server and DB2 is 15. The default value suffices for most environment in which a directory server is used. Based on the requirement, you can increase the database connection to unlimited. The upper limit that you can assign is INT_MAX (2147483647). You can modify the ibm-slapdDbConnections attribute to set the database connections. If you assign a value of less than or equal to zero, or greater than INT_MAX, then the default value of 15 is set.

You must determine the number of worker threads in use to assign an appropriate value for database connections. To find the number of worker threads, use the available_workers threads value in the monitor search result. To increase the workers threads or to increase the back-end connections, you must set ibm-slapdDbConnections under the cn=Directory, cn=RDBM Backends, cn=IBM Directory, cn=Schemas, cn=Configuration DN entry. To view the monitor search result, run the idsldapsearch command:

 idsldapsearch -p port -D adminDN -w adminPwd -s base -b "cn=monitor" objectclass=* \
| grep -i available_workers