72 DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
Application design
Keep in mind that the tuning of the server is important, but the best-tuned server
is slow if the database design or the application is badly designed.
The physical and logical designs of the database and the application are also
critical for performance. The database needs to become normalized to eliminate
redundant data. But for performance it is sometime useful to not have normalized
data. We discus this in Chapter 7, “Monitoring and tuning of DB2 UDB V8” on
page 237.
3.3 Tools
DB2 UDB provides some tools that help you in several tasks, like performance
optimization and maintenances tasks. In the following we introduce four of them.
3.3.1 IBM DB2 UDB Perf ...