Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Release Notes

Batch Run Schedule

Batch Run Schedule (Index Expert)

ClosedView the Batch Run Criteria Window (Batch Run Schedule)

The Batch Run Schedule criteria enable you to schedule when to start and stop the Batch Run.

Schedule setting

Start

Start Option

Description

Now

Specify to start the Batch Run immediately.

Date and Time

Specify to start the Batch Run at a specific date and time. If you click the month, day, year, you can use the up or down arrows to change the value.

After

Specify to start the Batch Run after it has been running for a specified number of hours and minutes.

Until

Until

Description

Finished

Specify to run the entire Batch Run until all SQL statements are executed.

Date and Time

Specify to terminate the Batch Run on the specified date and time. If you click the month, day, year, you can use the up or down arrows to change the value.

Duration

Specify to terminate the Batch Run after it has executed a specified number of hours and minutes.

Terminate immediately

(Date/Time and Duration only)

Specify to terminate the currently executing SQL statement and all remaining unexecuted SQL statements.

Terminate after currently executing SQL is finished

(Date/Time and Duration only)

Specify to finish running the currently executing SQL statement and do not create the remaining indexes and benchmark the SQL statement against them.

 

Related Documents