Chat now with support
Chat mit 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

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.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen