IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Warehouse Proxy Agent
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Configuration parameter changes used in large-scale environments
Configuration parameters for the Warehouse Proxy Agent are set in the following files according to operating system.
- ITM_HOME\TMAITM6\khdenv
For example: C:\IBM\ITM\TMAITM6\khdenv
- ITM_HOME/config/hd.ini
For example: /opt/IBM/ITM/config/hd.ini
This section contains configuration settings to the Warehouse Proxy Agent configuration files, that you might consider to improve performance in large-scale environments.
- KHD_WAREHOUSE_TEMS_LIST=REMOTE_<hostname>
- This value is needed when using multiple Warehouse Proxy Agents in a configuration. This value is set so that the Warehouse Proxy Agent services agents that are connected to the local remote monitoring server.
- KHD_EXPORT_THREADS=5
- With multiple Warehouse Proxy Agents in the configuration, you can lower this value from the default of 10 to reduce the number of concurrent connections to the warehouse database.
- KHD_CNX_POOL_SIZE=5
- With multiple Warehouse Proxy Agents in the configuration, you can lower this value from the default of 10 to reduce the number of concurrent connections to the warehouse database.
- KBB_RAS1=ERROR (UNIT:khdxdbex OUTPUT)
- You can add the trace setting (UNIT:khdxdbex OUTPUT) to the KBB_RAS1 entry. This setting causes export messages to write to the Warehouse Proxy Agent trace logs, which provides useful information for performance analysis with negligible overhead. This setting is useful if you are specifying KHD_WHLOG_ENABLE=N.
- DB2CODEPAGE=1208 (DB2 only)
- This setting avoids an initialization error message of DB2 client code page not found, which appears in the Warehouse Proxy workspace. The value that you use for the DB2CODEPAGE variable must be the same as what you specify on your CREATE DATABASE statement. For more information about setting the DB2CODEPAGE variable, see the IBM DB2 Database information center at http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp.
- NLS_LANG=AMERICAN_AMERICA.AL32UTF8 (Oracle only)
- This setting is used in place of DB2CODEPAGE if using Oracle for the warehouse database.
- KHD_JAVA_ARGS=-Xmx256m (UNIX/Linux only)
- Sets the maximum Java heap size for the khdxprtj Java virtual machine. This setting is useful in lowering the process size (SZ) and virtual size (VSZ) for the khdxprtj process on the Tivoli Enterprise Monitoring Server.
Parent topic:
Warehouse Proxy Agent