Tuning features

When you activate a license for InfoSphere Optim Query Workload Tuner on a DB2 database or subsystem, you can use the full set of tuning features. Even if you do not activate a license, however, you still can use a subset of those features.

No-charge features for tuning single SQL statements

You can use these features in the IBM Data Studio client, Version 3.2 whether or not a license for InfoSphere Optim Query Workload Tuner is active on the DB2 system where your SQL statements run.

Priced features for tuning single SQL statements

You can use these features in the IBM Data Studio client, Version 3.2 only if a license for InfoSphere Optim Query Workload Tuner is active on the DB2 system where your SQL statements run.
Table 1. Priced features for tuning single SQL statements
Feature InfoSphere Optim Query Workload Tuner DB2 for Linux, UNIX, and Windows InfoSphere Optim Query Workload Tuner DB2 for z/OS
Annotate formatted SQL statements with statistics
Create, validate, and deploy optimization profiles to modify access plans directly  
Drill down into the details of access plans with the Access Plan Explorer
Generate recommendations for creating indexes
Generate recommendations for improving access paths
Generate recommendations for rewriting SQL statements
Virtually test recommended indexes and indexes that you propose
Create, validate, and deploy plan hints to modify access plans directly  

Priced features for tuning query workloads

You can use these features in the IBM Data Studio client, Version 3.2 only if a license for InfoSphere Optim Query Workload Tuner is active on the DB2 system where your SQL statements run.
Table 2. Priced features for tuning query workloads
Feature InfoSphere Optim Query Workload Tuner DB2 for Linux, UNIX, and Windows InfoSphere Optim Query Workload Tuner DB2 for z/OS
Tune SQL statements that are captured from repositories in InfoSphere Optim Performance Manager
Tune SQL statements that are captured from text files
Generate recommendations for creating indexes
Generate RUNSTATS commands for fixing problems with statistics
Tune SQL statements that are captured from all supported sources in DB2 for Linux, UNIX, and Windows, including the package cache, packages, and SQL stored procedures  
Generate recommendations for creating or modifying statistical views  
Generate recommendations for MQTs, multi-dimensional clustering, and redistributing data across partitions  
Tune SQL statements that are captured from all supported sources in DB2 for z/OS, including the dynamic statement cache, plans, packages, and SQL stored procedures  
Compare, annotate, and generate reports on the access plans and estimated cost changes for SQL statements in different packages or workloads  
Create reports on the catalog information for tables that SQL statements reference  
Generate recommendations for improving access paths  
Generate recommendations for rewriting SQL statements  
Capture the environments of query workloads; send representations of the environments to IBM Support or re-create the environments on another subsystem  

Feedback