Generating reports
There are one or two types of reports that you can generate, depending on whether you are connected to DB2® for Linux, UNIX, and Windows or to DB2 for z/OS®.
Generating reports that summarize recommendations and information about the current SQL statement
When you run the single-query advisors on an SQL statement, you can summarize their recommendations in a report. The report also lists information about the access path for the SQL statement and catalog information about the relevant tables, columns, and indexes.
Generating access path reports for SQL statements that run on DB2 for z/OS
You can generate reports that show statistics for tables that an SQL statement references, details about predicates in the statement, and statistics for the indexes that the access plan uses.
Related tasks
:
Sharing the results of tuning single SQL statements
Gathering information about the environments in which SQL statements run on DB2 for z/OS
Related reference
:
Preparing for tuning
Locations from which you can capture an SQL statement for single-query tuning
Working with analysis tools and advisors
Advanced tuning techniques
Feedback