Aug
22
|
Abstract
The REORGDURATION option specifies an interval during which server-initiated table or index reorganization can start.
Content
Schedule server-initiated reorganizations to start during periods when server activity is low. Use this option together with the REORGBEGINTIME option. The REORGBEGINTIME option specifies the earliest time that the server can start a reorganization.
You can update this server option without stopping and restarting the server by using the SETOPT command.
See SETOPT (Set a server option for dynamic update).
Syntax
>>-REORGDURation–nn——————————————-><
nn
Specifies the number of hours during which a reorganization can start. The minimum value is 1, the maximum value is 24. The default value is 24.
Example
Specify an interval of four hours during which a reorganization can start.
reorgduration 4