| 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 for generating
recommendations about creating materialized query tables, multidimensional clustering, and
redistributing data across database partitions |
N |
9.7 FP6 and
later |
Y |
| Workload Table Organization Advisor for
recommendations about BLU acceleration |
N |
N |
10.5 and later |