All four of the InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner products share the Optim Query Tuner client. You can use this client to connect to any database or subsystem on which a license for one of these products is active.
Scope of tuning activities | Feature | Data Studio | InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows | InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows | InfoSphere Optim Query Tuner for DB2 for z/OS | InfoSphere Optim Query Workload Tuner for DB2 for z/OS |
---|---|---|---|---|---|---|
Single SQL statements and query workloads | Tune SQL statements that are captured from all supported sources in DB2 for Linux, UNIX, and Windows, including the package cache, packages, SQL stored procedures, and more | ✓ | ✓ | ✓ | ||
Tune SQL statements that are captured from all supported sources in DB2 for z/OS, including the dynamic statement cache, plans, packages, SQL stored procedures, and more | ✓ | ✓ | ✓ | |||
Tune SQL statements that are captured from repositories in Optim Performance Manager | ✓ | ✓ | ✓ | ✓ | ✓ | |
Tune SQL statements that are captured from text files | ✓ | ✓ | ✓ | ✓ | ✓ | |
Single SQL statements | Annotate formatted SQL statements with statistics | ✓ | ✓ | ✓ | ✓ | |
Capture the environment of single SQL statements; send the representation of the environment to IBM Support or recreate the environment on another subsystem | ✓ | ✓ | ✓ | |||
Create reports that summarize recommendations and information about database objects in access plans | ✓ | ✓ | ✓ | ✓ | ✓ | |
Create reports that summarize the statistics that the DB2 optimizer uses to create access plans | ✓ | ✓ | ✓ | |||
Create, validate, and deploy optimization profiles to modify access plans directly | ✓ | ✓ | ||||
Create, validate, and deploy plan hints to modify access plans directly | ✓ | ✓ | ||||
Drill down into the details of access plans with the Access Plan Explorer | ✓ | ✓ | ✓ | ✓ | ||
Format SQL statements for better readability and analysis | ✓ | ✓ | ✓ | ✓ | ✓ | |
Generate recommendations for creating indexes | ✓ | ✓ | ✓ | ✓ | ||
Generate recommendations for improving access paths | ✓ | ✓ | ✓ | ✓ | ||
Generate recommendations for rewriting SQL statements | ✓ | ✓ | ✓ | ✓ | ||
Generate RUNSTATS commands for fixing problems with statistics | ✓ | ✓ | ✓ | ✓ | ✓ | |
Generate visual representations of access plans for single SQL statements | ✓ | ✓ | ✓ | ✓ | ✓ | |
Tune SQL statements that you enter directly into the workflow assistant | ✓ | ✓ | ✓ | |||
Virtually test recommended indexes and indexes that you propose | ✓ | ✓ | ✓ | ✓ | ||
Query workloads | Compare, annotate, and generate report 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 creating or modifying statistical views | ✓ | |||||
Generate recommendations for creating indexes | ✓ | ✓ | ||||
Generate recommendations for improving access paths | ✓ | |||||
Generate recommendations for rewriting SQL statements | ✓ | |||||
Generate RUNSTATS commands for fixing problems with statistics | ✓ | ✓ |
Visit the product page for InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner.