Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics 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

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

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 image\I_RedCheckmark.gif 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 image\B_AddDatabaseObjects.gif 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 image\B_Remove.gif or drag that item out of the list box back to the tree diagram (Database objects).

    or

    Click the image\B_Ellipse.gif 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 Event Monitors

With the help of the DB2 Event Monitor you are able to capture SQL statements while they are currently running on the database server. Capturing SQL statements with the Event Monitor allows SQL Scanner to identify problematic SQL statements running on the database server.

To add an Event Monitor in the Add Jobs wizard

  1. In the DB2 Event Monitor page of the Add Jobs wizard, a list of available Event Monitors appears on the left-hand list box. Select Show all Event Monitors checkbox to display all the Event Monitors, or unselect to display only the Event Monitors owned by the currently selected schema.

  2. Select an Event Monitor and click image\B_AddDatabaseObjects.gif. If no Event Monitor files or tables are found in the target directory, then you will be prompted to enter the path of the Event Monitor.

  3. To scan the Event Monitors using a particular schema, select the Specify schema checkbox and select the schema using the Schema list.

 

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 image\B_Add.gif.

  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. 

 

Related Documents