SQL Performance Analyzer Reports

Select this main menu option to access the results from the DB2 SQL Performance Analyzer for z/OS® (SQL PA).

SQL PA analyzes former and current SQL queries and report the results. Analyses can be initiated from the following panels:

The results from SQL PA are SQL Enhanced Explain reports, SQL Query Limits reports, and SQL Trace information.

The output provided by SQL PA reports is based on SQL PA configuration parameters that are applied by means of the Configuration Tool. During the customization the affected DB2 subsystems and Performance Warehouse options to be used by SQL PA are determined.

When an SQL performance analysis is requested, the OMEGAMON Collector silently submits a batch job that captures the analysis data and puts it into appropriate Performance Warehouse tables, from where it is retrieved and reassembled and presented as an SQL PA report.

SQL PA reports might be long. If you cannot page down to the end of a report, the logical rows session parameter value might be too low. Log on again, with the session parameter set to a higher value. You can set this parameter either on the OMEGAMON XE for Db2 PE Classic Interface panel or as a logon command parameter, for example logon applid(ipobd2c) data(lrows=9999).