SQL Optimizer for DB2 ZOS 5.6.1 - Release Notes

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

Test Run Settings Options

Best Alternative Criteria Options

Execution Method Options