Managing Db2 performance
Managing the performance of Db2 is an iterative process. Periodically, or after significant changes to your system or workload, you must reexamine your objectives, and refine your monitoring and tuning strategy accordingly.
About this task
You can avoid some performance problems completely by planning for performance when you first design your system. As you begin to plan your performance, remember the following information.
- Db2 is only a part of your overall system. Any change to the system hardware, disk subsystems, z/OS®, IMS, CICS®, TCP/IP, VTAM®, the network, WebSphere®, or distributed application platforms (such as Windows, UNIX, or Linux®) that share your enterprise IT infrastructure can affect how Db2 and its applications run.
- The recommendations for managing performance are based on current knowledge of Db2 performance for
normal
circumstances andtypical
systems. Therefore, you need to understand that this information might not necessarily be the best or appropriate advice for every specific situation. In particular, the advice on performance often approaches situations from a performance viewpoint only. Other factors of higher priority might make some of these performance recommendations inappropriate for your specific solution. - The recommendations are general. Performance measurements are highly dependent on workload and system characteristics that are external to Db2.
Procedure
To manage Db2 performance, use the following approaches: