
Chapter 11. Performance tuning of DB2 UDB Workgroup Server 337
11.4 Monitoring and tuning tools
DB2 UDB offers several tools that help you monitor and tune your databases and
applications. Before you start tuning your system, you must have an idea of what
to tune. Monitoring helps you to determine what is going on in your system, for
example, if you have a long-running transaction and need to know why it is
running so long. One method to handle the problem is to try something and see if
it helps. The better method is to monitor the system, pinpoint the problem, and
resolve the problem.
Monitoring consumes system resources. Therefore, it is a ...