Chapter 13. DB2 Tuning and Optimization
In this chapter, we will cover:
Operating system tuning
Resolving CPU bottlenecks
Tuning memory utilization
Collecting object statistics with the RUNSTAT utility
Tuning with indexes
Tuning sorting
Hit ratios and their role in performance improvement
I/O tuning
Using logging and nologging modes
Using parallelism
Using EXPLAIN PLAN
Creating a benchmark testing scenario