Generating and acting on recommendations
The workload advisors can make several types of recommendations.
Generating and acting on recommendations for collecting statistics for query workloads that run on DB2 for z/OS
The Workload Statistics Advisor enables database administrators to collect statistics that are relevant to the SQL statements in an entire query workload.
Generating and acting on recommendations for indexes for improving the performance of query workloads that run on DB2 for z/OS
The Workload Index Advisor recommends new indexes and changes to existing indexes on tables that are referenced by SQL statements in query workloads.
Generating and acting on recommendations for revising SQL statements in query workloads for better performance
The Workload Query Advisor uses a set of rules and best-practices to find structures in SQL statements that are likely cause the optimizer to choose suboptimal access paths. You can rewrite the statements to resolve the problems that are identified in the recommendations.
Generating and acting on recommendations for changing the access paths for SQL statements in query workloads that run on DB2 for z/OS
The Workload Access Path Advisor examines the access plans that are chosen by the optimizer and identifies certain common access path issues.
Related tasks
:
Collecting EXPLAIN information about the statements in query workloads
Running analysis tools and advisors on single SQL statements
Adding SQL statements to query workloads
Consolidating EXPLAIN information
Monitoring query workloads
Gathering information for IBM Support about the environments for query workloads
Recreating workload environments on other subsystems
Related reference
:
Preparing for tuning
Locations from which you can capture SQL statements to create query workloads that run on DB2 for z/OS
Special cases of creating query workloads that run on DB2 for z/OS
Generating reports
Feedback