DB2 performance management

Managing the performance of a DB2® subsystem involves understanding a wide range of system components. You need to understand the performance of those components, how to monitor the components, and how to identify problem areas.

System resources, database design, and query performance are among the many performance issues to consider, and each of these factors influences the others. For example, a well-designed query does not run efficiently if system resources are not available when it needs to run.

To manage DB2 performance, you need to establish performance objectives and determine whether objects, resources, and processes are meeting your performance expectations. Tips and guidelines help you tune your DB2 subsystem to improve performance. Several tools are available to make performance analysis easier for you.