Before you can make effective judgements about how to tune the DB2 Server for VSE & VM product, you need to understand what happens inside each part of the product. This manual will help you understand:
This manual does not provide diagnostic information. (For the symptoms of common performance problems and potential cures, refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual.)
The chapters of this manual are arranged as follows:
Summary of Changes: Lists the changes made to the product since Version 6 Release 1.
Chapter 1, Improving Performance: This is an introduction to the subjects of performance design and tuning. It discusses the basic process including the development of goals, strategies and plans.
Chapter 2, Measuring Performance: This is an overview of the various tools available to measure the performance of the application server itself and as a part of the entire VM or VSE system.
Chapter 3, Managing Storage and Configuring the Operating System: This discusses how to effectively manage physical (DASD) and virtual storage. It also explains various operating system parameters and how to set them to optimize the performance of a system that includes a DB2 Server for VSE & VM application server.
Chapter 4, Configuring the Application Server and Requester: This explains the various subsystems in the application server and requester and how they can affect performance. It discusses how each initialization parameter governs how each subsystem operates, and where to look for performance indicators that describe how well each subsystem is performing.
Chapter 5, Improving Data Access Performance: This discusses how to improve performance by changing either how the data is accessed or by changing the structure of the data itself. The first method involves analyzing and rewriting SQL statements, while the second method involves reorganizing data, effectively managing indexes, and working with database statistics.
Chapter 6, Data Spaces Support for VM/ESA: This discusses how to improve the performance of your application server, by using the Data Spaces facility in VM/ESA.
Chapter 7, Tuning Performance for Data Spaces Support: This discusses the various tuning actions which can be used to improve Data Spaces Support performance.