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

Group Manager Window

In the SQL Scanner, a "group" is used to store "jobs". A Scanner group is a collection of database objects, DB2 Event Monitors, or text and binary files that you selected to group together. A Scanner job is one file or database object. Before you can start to work in the SQL Scanner, you must create a group.   

The Group Manager window is used to create, open, delete and rename Groups. It also displays a list of existing Groups. A Group must be opened to display the Job Manager window. Group Manager provides the following functions:




Opens the selected Group in Job Manager.


Creates a new Group.


Modifies the selected Group name or description.


Deletes the selected Group and all associated files.

Note: All Group information is stored as files in the SQL Scanner data directory defined in the Options window.


Open the SQL Scanner

To open the SQL Scanner

  1. Click image\B_SQLScanner.gif, the first window shown is the Group Manager window. If a Group has not been created before, the Create Group window appears.

  2. After creating a new Group or selecting an existing Group, click the Open. The Job Manager window appears after opening the working Group. If it is an empty group, the Add Jobs wizard also appears.


Add Scanner Jobs

Quest SQL Optimizer for IBM® DB2® LUWmaximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer


Add Jobs to the Job Manager Window

The Add Jobs wizard enables you to select the database objects, DB2 Event Monitors, application source, and binary files that you want to scan.

To add Jobs to the Job Manager window

Click image\B_AddJobs.gif.

Add Options

The following pages are for selecting which database objects, DB2 Event Monitors, or files to scan.

Database Objects

DB2 Event Monitor

Source Code

SQL Inspectors


Note: When you close the Add Jobs wizard, the newly added Jobs are automatically marked in the Job Manager window with a red checkmark image\I_RedCheckmark.gif in the far left of the row.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating