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.
There are a number of sources of database configuration and tuning
information that should be helpful in the planning, monitoring, and
tuning of the Tivoli Data
Warehouse:
- Understanding the disk requirements for your database describes factors to consider
in planning the disk subsystem to support the Tivoli Data Warehouse.
- The paper “Relational Database Design and Performance
Tuning for DB2® Database Servers”
is available from the Tivoli Integrated
Service Management Library by searching for "database tuning" or navigation
code "1TW10EC02" at IBM Integrated Service Management Library.
This paper is a concise reference describing some of the major factors
that affect DB2 performance.
This document is a good starting point to use before referencing more
detailed information in manuals and Redbooks® devoted
to DB2 performance. While DB2 specific, many of the concepts
are applicable to Relational Databases in general, such as Oracle
and Microsoft SQL Server.
- The “Tivoli Data Warehouse tuning” chapter of the Redbook Tivoli Management
Services Warehouse and Reporting (SG24-7443) builds upon the
previously referenced Tivoli Integrated
Service Management Library paper, supplementing it with information
about Oracle and Microsoft SQL Server.
This chapter is almost 100 pages in length.
- The “Optimizing the performance” chapter of the Redbook IBM® Tivoli Monitoring Implementation
and Performance Optimization for Large Scale Environments (SG24-7443) contains
a section on database tuning considerations for the Tivoli Data Warehouse. This section makes
suggestions about specific tuning parameters for DB2, Oracle and MS SQL. At approximately 12 pages,
this section is much shorter than the tuning chapter in the previously
referenced Redbook (item number 3).
The remainder of this section is a summarized version of material
from the Tivoli Integrated
Service Management Library paper in number 2 above, which has been supplemented
by identifying specific parameters relevant to Tivoli Data Warehouse and providing some suggested
ranges of values.