Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Open SQL from SQL Repository

SQL statements saved in the SQL Repository can be copied to the editable pane in other modules.

To copy SQL from the SQL Repository

  1. From an editable pane in a module other than the SQL Repository, select File | Open SQL from SQL Repository.

  2. Navigate through the tree structure and select the SQL statement.

  3. Click Open.


Save SQL to SQL Repository

To save SQL statements to the SQL Repository module

  1. Click image\B_SaveSQLtoSQLRepository.gif.

  2. Select the specific SQL to save and click the Save button.

  3. Select the location in which to save the SQL statements.

Only valid SQL statements can be added to the SQL Repository.

Supported SQL Statements

The SQL Repository only supports a single SELECT, INSERT, UPDATE, or DELETE SQL statement. 


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.


SQL Navigation

Several ways are provided to navigate through the SQL statements displayed in multiple tab sets.

  • Click the tab set at the bottom of the window.

  • Use the Navigate | Go to SQL function which navigates to a specify SQL number.

  • Use the navigation buttons on the toolbar or corresponding menu items.


Menu Item



Navigate | First SQL

Display the first SQL statement.


Navigate | Previous SQL 

Display the previous SQL statement.


Navigate | Next SQL 

Display the next SQL statement. 


Navigate | Last SQL

Display the last SQL statement.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating