SQL Optimizer for DB2 LUW 5.0 - User Guide

Add Jobs to the Job Manager Window

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

To add Jobs to the Job Manager window

Click .

Add Options

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

Database Objects

Source Code

SQL Inspectors

Summary

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

Add Database Objects

The SQL Scanner can scan all SQL statements within database objects. These include materialized query tables, views, procedures, functions, triggers, packages and plan tables. Depending on your database access privileges, available database objects can be selected by their object name, object type, or schema name.

To select database objects in the Add Jobs wizard

1. In the Database Objects page of the Add Jobs wizard, double-click each branch name to expand or collapse the associated list of sub-items.

2. Click an individual database object, object type, or schema.

3. Click or drag the item to the list on the right (Selected objects).

4. To remove an item from the right-hand box [Selected objects], click or drag that item out of the list box back to the tree diagram (Database objects).

   or

   Click the button to open the Add Database Objects window.

   1. Select the database, user, and object type.

   2. Using the % wildcard, enter the filtering criteria. The filter is case sensitive, so you must match the upper or lowercase of the database object.

   3. Select the database objects.

Add Source Code

The SQL Scanner can scan through any source code stored as a text or a binary file to identify SQL statements.

To select source code files in the Add Jobs wizard 

1. In the Source Code page of the Add Job wizard, select the file type: Text or binary files or COBOL programming source code.

2. Click .

3. Select the individual files.

4. Click Open.

5. Select the schema that corresponds with the SQL that you are scanning from the Schema box. 

Add SQL Inspectors

You may want to scan the SQL Inspector to identify the SELECT, INSERT, UPDATE and DELETE SQL statements with their query plan, abstract plan and trace on information (if available). This enables you to review the query plan and helps to give a better understanding of which SQL statement is causing the performance problem within the database server.

To add a SQL Inspector

1. Click the SQL Inspector page. The left-hand list field displays a list of available Inspectors. If you have not yet created any Inspectors, this list field is blank.

2. Select an Inspector and click or drag the Inspector you want to scan over to the right-hand list field.

3. Use the Set Scheme list to select the schema that corresponds with the SQL that you are scanning.

Related Topic

Add Jobs to the Job Manager Window