SQL Optimizer for DB2 LUW 4.3.1 - User Guide

Move or Copy Jobs to Another Group

To move Jobs in the Job Manager to another Group

1. Mark the Jobs to be moved.

2. Select Group | Move to Other Group.

3. Select the Group when you want to move the Jobs in the Move to box.

To copy Jobs in the Job Manager to another Group

1. Mark the Jobs to be copied.

2. Select Group | Copy to Other Group.

3. Select the Group when you want to move the Jobs in the Copy to box.

Modify Job Details

You can modify the Job description, change the file type for source code files, and eliminate duplicate SQL while scanning.

Modifying a Job deletes the current scanning information.

To modify the Job

1. Mark the Jobs to be modified.

2. In the Job Manager window,right-click and select Modify.

3. The Modify Job dialog box allows you to do the following:

   Item	Description
   Description	Add an comment about the Job. This description is only displayed in Modify Job window.
   Job Type	When the Job is a source code file, select either Text or binary files or COBOL programming source code.
   Eliminate duplicate SQL	Check Eliminate duplicate SQL to only extract the identical SQL statement once for each Job.

4. Click OK.

5. Since modifying the Job deletes the current scanning information, click to rescan the Job if desired.

Switch Schema

The Schema that is used to retrieve the access plan when the SQL statement is scanned is displayed in the File / Database Object column in the Job Manager window.

To change the schema used to scan a particular Job

1. Right-click a Job and select Set Schema.

2. Select the schema name from the list.

Change Event Monitor Path

To change the data directory for a DB2 Event Monitor Job

1. In the Job Manager window, right-click the DB2 Event Manager Job and select Change Event Monitor Path.

2. Select the directory path.