Single-query tuning features by product
Tuning
features are available in Optim™ Query
Tuner for DB2 for Linux, UNIX,
and Windows, Optim Query
Tuner for DB2 for z/OS,
and Optim Query
Workload Tuner for DB2 for z/OS.
A subset of these features is available in Data Studio Integrated Development Environment and Data Studio stand-alone.
Sharing analysis results
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.
Creating and deploying plan hints
You can create, validate, and deploy a plan hint for an
SQL statement that runs on a DB2 for z/OS subsystem. With a plan hint,
you can set criteria to assist the DB2 optimizer
to select the optimal execution plan for the SQL statement.