IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions: common procedures > Tuning the performance of the Warehouse Proxy
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Connection pool
The Warehouse Proxy uses several pre-initialized ODBC connections to access the target database. The use of these ODBC connection objects is synchronized through a single connection pool. The connection pool is initialized when the Warehouse Proxy starts.
You can configure the number of connections in the pool by defining the following environment variable in the KHDENV file on Windows or the hd.ini file on Linux and UNIX:
- KHD_CNX_POOL_SIZE: The total number of pre-initialized ODBC connection objects available to the work queue export threads. The default value is 10.
All export worker threads request connections from the connection pool and must obtain a connection before the work of exporting data can continue.
You only see the connections established when a request is active. It is important to set the number of worker threads to greater or equal to the number of ODBC connections. To do this, set KHD_KHD_EXPORT_THREADS >= KHD_CNX_POOL_SIZE.
Parent topic:
Tuning the performance of the Warehouse Proxy