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 access path reports for SQL statements that run on DB2 for z/OS
If you are using InfoSphere® Optim™ Query Tuner for DB2 for z/OS or InfoSphere Optim Query Workload Tuner for 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.