IBM® InfoSphere® Optim™ Query
Workload Tuner provides advanced query tuning capabilities for individual
SQL statements that run on DB2® for Linux, UNIX, and Windows databases
or on DB2 for z/OS® subsystems.
Preparing for tuning
Before tuning SQL statements, 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.
Declaring global temporary tables before tuning
If the statement that you want to tune accesses global
temporary tables, you must run the statements that define the temporary
tables before you run analysis tools on your statement.
Generating reports
There are one or two types of reports that you can generate,
depending on whether you are connected to DB2 for Linux, UNIX, and Windows or to DB2 for z/OS.
Sharing the results of tuning single SQL statements You can export recommendations from
advisors, access plan graphs, formatted SQL statements, and reports,
so that other people can import them into their workspaces and view
them.
Advanced tuning techniques
You can use several tuning techniques that go beyond the
recommendations of the advisors and influence access plans directly.