10.3.6 execstop statement (specification of pdrbal execution time)

The execstop statement specifies a pdrbal execution time to stop pdrbal at a specific time.

Criterion
Specify the execstop statement to avoid executing pdrbal when there are many online transactions, such as during business hours.
Rules
  1. When the execstop statement is omitted, the utility continues the rebalance operation until it is completed.
  2. Even when the specified termination time is reached, the utility continues processing until all row data (including indexes) involved in the rebalance operation has been moved. Therefore, the utility's processing may not terminate by the specified time. In the batch index creation mode, the index is created in the batch mode after data has been moved. Take this into account when you specify the termination time.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

execstop time,pdrbal-execution-time

(2) Explanation

(a) pdrbal-execution-time

Specify the pdrbal execution time (HH:MM).

HH: Hours (00-168)
MM: Minutes (00 or 30)

This value cannot be greater than 168 hours (one week). If 00 is specified for both HH and MM, the utility terminates immediately without executing the rebalance operation (however, at the startup, pdrbal executes the access procedure for search, deletion, and update processing, deletion of SQL objects, and recompilation of a procedure/function for which an SQL object is invalid).

Example:
Execute pdrbal from 21:00 to 9:00 (12 hours) when there is not much traffic:

execstop time,12:00