Generating reports
You can generate two types of reports.
Generating reports of recommendations
You can generate, save, and print reports that list recommendations from the workload advisors.
Generating table reports for query workloads
You can generate a report to see information about the tables that are referenced in the SQL statements of an entire workload.
Related concepts
:
Generating and acting on recommendations
Related tasks
:
Collecting EXPLAIN information about the statements in query workloads that run on DB2 for z/OS
Virtually testing recommended indexes and indexes that you propose for query workloads that run on DB2 for z/OS
Dropping existing indexes virtually before running the Workload Index Advisor on query workloads that run on DB2 for z/OS
Consolidating EXPLAIN information
Gathering information for IBM Support about the environments for query workloads
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
Feedback