Tuning features by product

This table lists the features for tuning SQL statements and query workloads, and the products in which those features are available.

Both of the InfoSphere® Optim™ Query Workload Tuner products use IBM® Data Studio full client or IBM Data Studio administration client.

Table 1. Features for tuning, according to product.
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.


Feedback