Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.5.1 - Installation Guide

Order and Termination Options

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set order and termination options

  1. Click .
  2. Select Optimize SQL | Test Run | Order and Termination

  3. Review the following for additional information:

    Execution Order Description

    Execution order for SQL

    Select one of the following options:

    • Intelligent order—Executes representative SQL statements with various plan cost according to SQL Optimizer's intelligence engine.
    • Plan cost—Executes SQL statements in order of plan cost.
    SQL Termination Criteria Description

    Terminate execution of SQL alternative if it runs longer than

    Select one of the following options:

    • Run time of fastest SQL—Cancels SQL statements that run longer than the current fastest run time. With this option, the first SQL statement runs and the time from that statement is used as the termination time for the next SQL statement. When a SQL statement runs faster than this time, the faster time is used as the new termination time.
    • This percentage of the original SQL run time—Cancels SQL statements whose total elapsed time is the specified % of the total elapsed time for the original SQL statement. It terminates all SQL statements that run longer than the calculated termination time.
    • User defined time (mins/secs)—Cancels SQL statements that run longer than a time you specify.
    • Run without termination—Runs all SQL statements to completion regardless of run time.

    Cancellation delay (seconds)

    Adds a specified time to the termination time. It is important to factor a delay into the overall termination time to account for the time needed to send the SQL statement to the database server.


Related Topics

Execution Method Options

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating