7.1 Tools for monitoring and tuning

---

Overview

Performance tuning begins at the design phase. The performance goals of both the system and the application should be specified in the project requirements. The performance requirements should be considered in the design and implemented while the application is being developed. In this chapter we show you the performance considerations and tuning methods of a database and an application starting from the design stage.

We introduce some tools that are useful in monitoring and tuning the system. These tools are all part of DB2 UDB, and there is no need to spend extra money buying these software.

We then discuss database- and application-related performance topics that DBAs and developers should consider while building and developing the system.

Finally we show how to administer a running system. We show you where you can find the information you need to monitor your running system. We describe what you should look at and how to tune it if there is problem.

---