SQL Optimizer for DB2 LUW 5.0 - User Guide

Modify SQL

You can only modify the SQL name and description of the SQL statements stored in the SQL Repository.

To modify the name or description

1. From the SQL Repository window, select the SQL you want to modify from the left pane.

2. Right-click and select Modify to open the Modify SQL window.

3. Modify the name and/or description.  

Note: SQL text cannot be modified. You must delete the current SQL and recreating a new one to change the SQL text.

Rename SQL

You can rename a SQL statement stored in the SQL Repository window in two ways:

To rename a SQL statement

1. Select the SQL you want to modify from the left pane.

2. Right-click and select Rename. Change the name and press Enter.

   or

   Select Modify and change the name.

Delete SQL

When you delete a SQL statement in the SQL Repository, it will delete all references.

To delete a SQL statement stored in the SQL Repository

1. Select the SQL you want to delete.

2. Right-click and select Delete or press the Delete key to delete the selected SQL statement and all references to this SQL statement in other modules.

3. If the SQL statement is in an Index Impact Analysis or an Index Usage Analysis, you will be prompted before it is deleted.

Create Benchmark Factory Import File

All the SQL statements can be saved in a text file from the Job Manager, the Scanned SQL Viewer, the SQL Repository, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory program (version 4.6 or later).

To create the text file to import into Benchmark Factory

1. Right-click and select Create Benchmark Factory Import File.

2. Select the specific SQL statements that you want to save. Click OK.

3. Enter the filename and select the file location. Click Save.