IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Tivoli Data Warehouse
The Tivoli Data Warehouse is the most intensely used component of the Tivoli Monitoring infrastructure. The warehouse must support a large volume of data transactions during every warehousing period, daily summarization and pruning of the warehoused data and multiple queries that often return result sets that are thousands of rows long. The processing power required to support the warehouse database and the Summarization and Pruning Agent can be significant.
This section provides guidelines for setting the Tivoli Data Warehouse. If you are interested in additional information, see the Tivoli Management Services Warehouse and Reporting Redbook.
The following topics outline processes for optimizing the performance of the warehousing process:
- For all but the simplest environments, database administrator skills are needed to manage the warehouse database
Database tuning is a complex task, and for most databases it requires the skills of a database administrator. For the Tivoli Data Warehouse, a database located on a single disk using default setting database parameters is only suitable for small test environments.
- Historical data collection
This section contains recommendations related to historical data collection and controlling the volume of data that is generated and loaded into the Tivoli Data Warehouse.
- Warehouse Proxy Agent
The Warehouse Proxy Agent provides a means of translating and transferring historical data collected by other monitoring agents to the Tivoli Data Warehouse.
- Summarization and Pruning Agent
The Summarization and Pruning Agent is a multi-threaded, Java based application. It interacts with the warehouse using a JDBC driver appropriate for the database of the warehouse. The number of worker threads available and the heap size of the JVM affect the performance of the Summarization and Pruning Agent and the length of time of its processing runs.
- Database tuning
Database tuning is a complex task, and for important databases, it requires the skills of a database administrator. For the Tivoli Data Warehouse, a database located on a single disk using default database parameters is suitable only for small test environments. For all other environments, careful planning, monitoring, and tuning are required to achieve satisfactory performance.
- Relational database design and performance tuning for DB2 Database servers
This section explains some of the major factors that affect DB2 performance on distributed platforms such as Windows, UNIX, and Linux. Many of the concepts are applicable to the topic of relational databases such as Oracle and Microsoft SQL Server.
Parent topic:
Performance tuning