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

View Job Properties

The Job properties provides information about a SQL Scanner Job.

To view the Job properties information

  1. In the Job Manager window, select the Job.

  2. Right-click and select Properties.

The Job Properties window displays the following information:

General tab

Item

Description

Name

Job name.

Type

Type of Job scanned (text/binary file, COBOL file, DB2 Event Monitor, database object).

Description

Job description.

Last modified

Last modified date and time.

Size

Job size.

Data Directory

Directory where the files are stored.

Status

Job status.

Version

Version number of SQL Optimizer when the Job was last scanned.

SQL Summary tab

Displays a pie chart showing the number and percentage of Problematic, Complex, Simple, and Invalid SQL statements.

 

Open Group Manager

You can use the Group Manager window to open, create, delete or modify a Group without closing the Job Manager window.

To open the Group Manager from the Job Manager window

Click image\B_GroupManager.gif.

 

Check Scanned SQL

After scanning is completed, you can review the scanned SQL statement in the Scanned SQL Viewer window. The SQL classification types (Problematic, Complex, and Simple) highlight which SQL needs attention first. It is recommended that you look at Problematic SQL, followed by Complex SQL. After you have reviewed a scanned SQL statement you can mark the SQL as checked. This indicates that the SQL statement had been reviewed and does not need any more attention.

Figure: Checked List Window

 

You can bring up the Checked List window from both the Job Manager and Scanned SQL Viewer windows.

To open the Checked List window

  • From the Job Manager window, select Job | Checked List or right-click and select Checked List .

  • From the Scanned SQL Viewer window, select SQL | Checked List or use the right-click and select Checked List.

To mark a Scanned SQL statement as checked

  1. All the valid SQL statements are listed on the left pane (e.g.) SQL1, SQL2 … SQLn . Select the SQL statement you want to check.

  2. To ensured that the SQL statement is the one you want to check, you can view the SQL text by clicking the SQL Preview tab.

  3. On the Checked Details tab, click the Check button. All editable fields are changed to edit mode.

  4. Modify the Checked by, Status, and Details information.

    Item

    Description

    Checked on

    Read-only field display the current date and time.

    Checked by

    Enter the user name that checked the SQL. By default, the computer user name is entered.

    Status

    Select the reason why you checked the SQL.

    Details

    Enter a short description.

  5. Click Apply.

  6. Click Close. A blue checkmark image\I_BlueCheckmark.gif appears next to the SQL name at the left pane to indicate that the SQL statement is checked.

You can automatically add a scanned SQL statement to the Checked List when you use the Send to SQL Optimizer or Send to Index Expert function.

To Add the Scanned SQL Statement to Checked List Automatically

In the Options window on the SQL Scanner tab under General button, select Always add SQL in the Checked List section.

To unmark a checked SQL statement

  1. Select the SQL statement you want to unmark from the left pane of the Checked List window.

  2. Click Uncheck.

The blue checkmark image\I_BlueCheckmark.gif is removed from the SQL name on the left pane.

Preserve Checked SQL Information When Rescanning

If you would like to preserve the Check SQL information when a Job is rescanned , select the Do not remove Check SQL information when rescanning checkbox in the Checked List section in the Options window on the SQL Scanner tab under the General button.

 

Mark and Unmark Jobs

The SQL Scanner only scans Jobs that are "marked."

To mark a Job

Clicking the Job row. The image\I_RedCheckmark.gif red checkmark will be prefixed to the File / Database Object column. Multiple Jobs can be marked at a time. If there are no marked Jobs, the Scan button is dim and scanning cannot begin.

To unmark a Job

Click the marked row.

To mark the selected Jobs

  1. Using click, shift click, and control click, highlight Jobs.

  2. Right-click and select Mark Selected Jobs.

To unmark the selected Jobs

  1. Using click, shift click, and control click, highlight Jobs.

  2. Right-click and select Unmark Selected Jobs.

To mark all Jobs in the Job Manager window

Select Group | Mark All [Ctrl + M].

To unmark all Jobs in the Job Manager window

Select Group | Unmark All [Ctrl + U].

The red checkmark image\I_RedCheckmark.gif is added to the File / Database Object column to indicate that the Job is marked. To show that the Job is unmarked, any appended symbol is removed to indicate that the job is unmarked.

 

Related Documents