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

Find a Job

To search for a specified text in all Jobs in the Job Manager window

  1. Select Job | Find Job.

  2. Enter the text string to be located.

  3. Click Find.

All the Jobs and number of the corresponding SQL statements will be listed.

 

View Group Summary

The Group summary report provides a statistical list of all the Jobs and SQL statements scanned within the Group.

To view the summary information

In the Job Manager Report | Group Summary window, select .

 

View Group Properties

The Group progtfrhnbperties provides information about SQL Scanner Group.

To view the Group properties information

  1. Select a Group in the Group Manager window.

  2. Right-click and select Properties.

The Group Properties window displays the following information:

General tab

Item

Description

Name

Group name.

Description

Group description.

Last modified

Last modified date and time.

Size

Total size of the Jobs within the Group.

Data Directory

Directory where the files are stored.

Version

Version number of SQL Optimizer when the Group was created.

Total Job

Total number of Jobs.

Completed

Total number of Jobs that were scanned.

Remaining

Total number of Jobs that had not been scanned.

SQL Summary tab

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

 

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.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen