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
Database initialization
This section contains the tests and environment variables used during database initialization.
When the Warehouse Proxy starts, the following tests are done:
- Checks that the Warehouse Proxy can connect to the database.
- If the database is Oracle or DB2 for Linux, UNIX, and Windows, checks that the encoding is set to UTF8.
- If the database is DB2 for Linux, UNIX, and Windows, checks that a bufferpool of page size 8KB is created. If it is not, one is created, along with three new table spaces that use the 8KB bufferpool. The bufferpool is called "ITMBUF8K" and the table spaces are named "ITMREG8K," "ITMSYS8K," and "ITMBUF8K."
- Creates a database cache that contains a list of all the tables and columns that exist in the database.
If any of these tests fail, a message is written to the log file and messages are displayed in the Event Viewer.
These tests are repeated every 10 minutes.
You can change this default start up behavior by changing the following environment variables:
- KHD_CNX_WAIT_ENABLE
- Enables the Warehouse Proxy to wait in between attempts to connect to the database. By default, this variable is set to Y. If you do not want the Warehouse Proxy to wait, change the variable to N. However, this can generate a large log file if the connection to the database fails with each attempt.
- KHD_CNX_WAIT
- Defines the amount of time, in minutes, that the Warehouse Proxy waits between attempts to connect to the database. The default value is 10 minutes.
Parent topic:
Tuning the performance of the Warehouse Proxy