Both of the InfoSphere® Optim™ Query Workload Tuner products use IBM® Data Studio full client or IBM Data Studio administration client.
Scope of tuning activities | Feature | Data Studio full client or administration client, Version 3.1.1, connected to a database or subsystem on which there is no active license for InfoSphere Optim Query Workload Tuner | InfoSphere Optim Query Workload Tuner for DB2® for Linux, UNIX, and Windows, Version 3.1.1 | InfoSphere Optim Query Workload Tuner for DB2 for z/OS®, Version 3.1.1 |
---|---|---|---|---|
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 MQTs, multi-dimensional clustering, and redistributing data across partitions | ✓ | |||
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 Workload Tuner.