Support for features on specific versions of DB2

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