Tuning query workloads that run on DB2 for Linux, UNIX, and Windows
IBM® InfoSphere® Optim™ Query
Workload Tuner for DB2® for Linux, UNIX, and Windows provides
tools for improving the performance of query workloads.
For a list of scenarios in which query-workload tuning can
be helpful and steps that you can follow for each scenario, see Scenarios for tuning query workloads.
Preparing to tune query workloads
Before tuning query workloads, ensure that you have the
right authorities and privileges, that the full set of tuning features
is activated on your data server, that global default values are set
to the values that you want, and that other important default values
are set.
Virtually testing BLU acceleration
You can virtually convert row-organized tables to column organization to determine
whether the conversion would improve the performance of a query workload. You can also virtually
create shadow tables for row-organized tables that are involved in analytical queries.