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
Read syntax diagramSkip visual syntax diagram
>>-REORGDURation–nn——————————————-><

Parameters

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

 

written by Bosse


Comments are closed.

i3Theme sponsored by Top 10 Web Hosting and Hosting in Colombia