Some of the features in InfoSphere Optim Query Workload Tuner are supported only on specific versions of DB2.
| 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 |
| 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 |