Aug 22

New server option REORGDURATION

DB2, Server Command Comments Off on New server option REORGDURATION

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

Aug 22

New server option REORGBEGINTIME

DB2, Server Command Comments Off on New server option REORGBEGINTIME

Abstract

The REORGBEGINTIME option specifies the earliest time that the Tivoli® Storage Manager server can start a table or index reorganization.

Content

Schedule server-initiated reorganizations to start during periods when server activity is low. Use this option together with the REORGDURATION option. The REORGDURATION specifies an interval during which reorganization can start.

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
>>-REORGBEGINTime–hh:mm—————————————><

Parameters

hh:mm
Specifies the time that the server can start a reorganization: The default start time 6:00 a.m. Use a 24-hour format to specify the time.

Time Description Values
hh The hour of the day Specify a number 00 – 23.
mm The minute of the hour Specify a number 00 – 59.

Examples

Specify 6:00 a.m. as the earliest time that a reorganization can start.
reorgbegintime 06:00
Specify 8:30 p.m. as the earliest time that a reorganization can start.
reorgbegintime 20:30
Specify noon as the earliest time that a reorganization can start.
reorgbegintime 12:00
Specify 3:30 p.m. as the earliest time that a reorganization can start.
reorgbegintime 15:30
Specify midnight as the earliest time that a reorganization can start.
reorgbegintime 00:00

 

written by Bosse