SQL Optimizer for DB2 ZOS 5.0

The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives. You can then test run these alternatives in the SQL Optimizer window to determine the best-performing version of the SQL.

Note: The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.

Create Optimize SQL Sessions

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

To create a new session

Select the Optimize SQL tab in the main window.
Click .

To add a session

Click

besides the Session tab.

Note: You need to create a new connection for each new SQL Optimizer session.

Open Optimizer SQL Sessions

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

To open a session

Select the Optimize SQL tab in the main window.
Click .
Select a Optimize session to open..

Select Connection

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

To select a connection

Select the Optimize SQL tab in the main window.
Click

Review the following for additional information:

Select Connection	Description
Connection	Click to select a previously created connection. Tip: Click to open the Connection Manager to create a new connection. See Connect to the Database for more information.
Select Schema and SQLID	Description
Schema	Click to select a schema for the connection.
SQLID	Click to select your SQLID.