Features by product

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

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.

Table 1. Features for tuning, according to product.

This table groups features by their scope. The features that you can use when tuning both single SQL statements and query workloads are in the first group. The features that you can use when tuning single SQL statements only are in the second group. The features that you can use when tuning query workloads only are in the third group.

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.


Feedback