SQL Statement Analysis

The top of the SQL statement analysis window shows the text of the SQL statement, while the statement analysis report displays below it. Select the SQL statement analysis report from the menu at the top of the window:

The following SQL statement analysis reports are available when you have requested that they be created when creating a Performance Profile from a measured DB2 application:

• EXPLAINidentifies the Db2 access path for a measured SQL request
• Translationcorrelates and reports access path explanations with relevant Db2 catalog information about database objects
• Observationssupplies specific recommendations for improving SQL statement efficiency using well documented rules
• Catalog Statisticsdisplays the Db2 catalog statistics.

To change the way iStrobe displays the SQL statement analysis reports:

1. Select Report preferences from the Options menu.
2. On the iStrobe report preferences page, scroll to the SQL statement analysis pop-up window section. Select Single pop-up to view each statement analysis in the same browser window, or Multiple pop-ups to view each statement analysis in an additional new browser window.
3. Click Set SQL window option to change the viewing option.