Version 10.1 contains
numerous SQL performance enhancements that continue to make the DB2® data server an industrial-strength
data server solution that is suitable for any size of organization.
RUNSTATS and database statistics improvements
There are a number of improvements
to the RUNSTATS command to make the gathering of
statistics faster in some cases. The command parameters also are simplified.
Intrapartition parallelism improvements
One goal of the DB2 query
optimizer is to choose parallel execution strategies that maintain
data balance among subagents and keep them equally busy. In this release,
the parallelization capabilities of the optimizer have been further
enhanced to enable more workloads to better use multi-core processors.
FP2: Recovery history file improvements might increase performance
The process of writing to the recovery history file in DB2 Version 10.1 Fix Pack 2 is now
more efficient. This improvement might result in general speed increases,
especially as the recovery history file size increases. These speed
improvements occur automatically; no change to the system or queries
are required.