SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Add Database Objects (Add Jobs Wizard)

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.