Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Batch Termination

ClosedView the Batch Run Criteria Window—Batch Termination 

The Batch Termination page of the Batch Run Criteria window is used to determine if and when to terminate the Batch Run. It enables you to find SQL and index-set alternatives that give you performance improvement without having to execute every alternative.

Tip: To save all settings on the Batch Run Criteria dialog for subsequent batch runs, select Save setting for the next batch run.

Batch Run Termination Criteria

Option

Description

No termination

Specify to run the Batch Run to completion.

Terminate Batch Run if the specified number of SQL/Index Sets falls in the criteria

Specify to terminate the Batch Run when a specified number of alternatives are found that meet the following requirements for terminating the Batch Run.

Number of SQL/Index Sets (excluding the Original)

Specify how many alternatives must be found that show performance improvement over the original SQL before the Batch Run will be terminated. 

Count the SQL/Index Sets if its elapsed time is faster than

Specify one of the following criteria to determine how the performance improvement is determined.

Original SQL

Count all alternatives that run faster than the elapsed run time from the original SQL.

Original SQL with a percentage of improvement

Count all alternatives where the elapsed run time for the alternative is the specified percentage faster than time for the original SQL statement.

User-defined time (mins/secs)

Count alternatives that run faster than a specified number of minutes and/or seconds.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating