Some of the features in InfoSphere® Optim™ Query
Workload Tuner are supported only on specific versions of DB2®.
Support for features on specific versions of DB2 for Linux, UNIX,
and Windows
Features
that are not listed in the table are supported for all in-service
versions of DB2 for Linux, UNIX,
and Windows.
Table 1. Support
for features on specific versions of DB2 for Linux, UNIX, and Windows| Features |
V95 |
V97 |
V10 |
| Capture SQL
statements from the package cache |
Support for
dynamic statements only. To capture I/O metrics and other performance-related
metrics, you must set the DB2 statement
monitor switch to "ON". |
Y |
Y |
| Capture from IBM® InfoSphere Optim Performance
Manager repository |
N |
Y |
Y |
| Capture from
activity event monitor |
Y (You
cannot generate an access plan graph from a statement immediately
after capturing that statement.) |
Y |
Y |
| Collect actuals |
N |
Y |
Y |
| Optimization
profiles |
N |
9.7 FP2 and
later |
Y |
| Locking down
access plans |
N |
9.7 FP7 and
later |
10.1 FP2 and
later |
| Workload Design
Advisor |
N |
9.7 FP6 and
later |
Y |
| Workload Table
Organization Advisor |
N |
N |
10.5 and later |
Support for features on specific versions of DB2 for z/OS
Features that are not listed in
the table are supported for all in-service versions of DB2 for z/OS®.
Table 2. Support for features on specific versions of DB2 for z/OS| Features |
V9NFM |
V10NFM |
V11NFM |
| Statement-level
access path hints and optimization parameter hints |
N |
Y |
Y |
| Creating and
updating RUNSTATS profiles |
N |
Y |
Y |
| Statistics
Collection Advisor |
N |
N |
Y |