SQL Optimizer for DB2 ZOS 5.6

Chat now with support

SQL Optimizer for DB2 ZOS 5.6 - Release Notes

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To view SQL information

Select the SQL Information tab in the Optimize SQL window. Click the following to view the information that displays for each pane.

SQL Information	Description
Classification	Statement type as classified by SQL Optimizer. Types include Simple, Complex, or Problematic.
Classification Rules Detail	Description
Details	Applicable SQL Classification Rules. Rules used for the classification process are set on the SQL Classification Options page.
Note: SQL Classification information only displays for the original SQL statement.

Plan Generation Details	Description
Semantically equivalent SQL statements	Number of semantically equivalent SQL statements generated by SQL Optimizer.
Alternative execution plans produced	Number of alternative execution plans produced for the original SQL statement.
SQL statements eliminated due to identical execution plans	Number of statement alternatives eliminated because they had the same execution plan as the original SQL statement. Note: SQL statements with the same execution plan have the same run time because the database executes these statements in the same way. SQL Optimizer eliminates these alternatives.
Plan Generation Time Details	Description
Plan generation started at	Time plan generation started.
Plan generation finished at	Time plan generation finished.
Total plan generation time	Total time to complete plan generation.
Average plan generation time	Average time to generate each plan alternative.
Notes: This information is only available after you generate plan alternatives. Plan generation details only display for the original SQL statement.

SQL Optimizer for DB2 ZOS 5.6 - Release Notes