6.1 Troubleshooting and tuning the historical database It is important to understand how the IBM Tivoli Monitoring V6.1 historical database works to be able to first understand how to tune and troubleshoot. 6.1.1 Tivoli Data Warehouse V2.1 overview and architecture Tivoli Data Warehouse V2.1 has two processes that collect, summarize, and prune data gathered from IBM Tivoli Monitoring V6.1 agents. The Warehouse Proxy Agent is the data warehouse server. The Warehouse Proxy Agent collects data from the IBM Tivoli Monitoring V6.1 agents and stores the data in a relational database (DB2, Oracle, or Microsoft SQL). Tivoli Data Warehouse V2.1 can optionally be configured to summarize and prune the historical data with another process called the Warehouse Summarization and Pruning Agent. If you choose not to run the Summarization and Pruning Agent, you still get historical, detailed data in the database tables. However, you do not get summarized data if you do not run the Summarization and Pruning Agent. Therefore, if you are trying to determine if any data is being collected from the Tivoli Enterprise Monitoring Agents, you need to make sure that the Warehouse Proxy Agent is running. Figure 6-1 shows an overview of historical data collection.