To schedule table or index reorganization, you specify
the earliest time and an interval after that time during which reorganization
can start.
Procedure
To schedule table or index reorganization, complete the
following steps:
- Enable table or index reorganization by setting one or
both of the following server options to yes in the dsmserv.opt file.
- ALLOWREORGTABLE
- ALLOWREORGINDEX
- Specify the time that the server can start table or index
reorganization by setting the REORGBEGINTIME server
option. Specify the time by using a 24-hour format. The best time
to start a reorganization is when server activity is low and when
access to the database is optimal. Schedule table reorganization for
databases on servers that are not running data deduplication. Schedule
table and index reorganization on servers that are running data deduplication.
- Specify the interval during which table or index reorganization
must start by setting the REORGDURATION server option.
Specify the time as a number of hours.
Results
If you set only the
REORGBEGINTIME option,
reorganization is enabled for an entire day. If you do not specify
the
REORGBEGINTIME option, but you specify a value
for the
REORGDURATION option, the reorganization
interval starts at 6:00 a.m. and runs for the specified number of
hours.
If your system experiences performance problems, modify the
values of the REORGBEGINTIME option and the REORGDURATION option.
When you modify the values, you ensure that table or index reorganization
is not running during periods of peak server activity.