Managing system performance

By considering performance as you design and configure your system, you can help to ensure better performance from Db2.

z/OS performance options for Db2
You can set z/OS® performance options for Db2 by using z/OS Workload Manager.
Configuring IBM z Integrated Information Processor (zIIP) specialty engines for Db2
Portions of certain Db2 processing are eligible for dispatching, as implemented by IBM® z Integrated Information Processor (zIIP) specialty engines.
IBM zEnterprise Application Assist Processor (zAAP) and Db2
The IBM zEnterprise® Application Assist Processor (zAAP) is a specialty engine that provides an execution environment for certain service-oriented architecture (SOA) technologies, such as Java™ and XML.
Managing I/O processing, response time, and throughput
To ensure that Db2 meets your goals for response time and throughput, you must manage how your system uses I/O processing.
Configuring storage for performance
Increasing the I/O rate and decreasing the frequency of disk access to move data between real storage and storage devices is key to good performance.
Configuring subsystems for concurrency
You can use system settings and Db2 subsystem parameters to improve concurrency.
Optimizing subsystem parameters
You can set certain subsystem parameter values to help optimize how Db2 processes SQL queries.
Improving Db2 log performance
By understanding the day-to-day activity on the log, you can more effectively pinpoint when problems occur and better understand how to tune for best performance.
Tuning parallel processing
You can improve the use of parallel processing by ensuring the availability of buffer pools, minimizing logical and physical contention and other situations that might reduce the degree of parallelism.
Improving the performance of stored procedures and user-defined functions
You can improve the performance of stored procedures and user-defined functions by following certain recommendations.
Insert algorithm 2
Insert algorithm 2 (IAG2) can increase throughput of INSERT statements, reduce logging, and reduce class 2 elapsed time and class 2 CPU time in certain conditions.

Parent topic: Managing Db2 performance