Setting reference options
These steps are part of the larger task of
reorganizing a table space or an index. When
you complete the steps for setting the reference
options, return to the main task.
Using the reference option means that reorganization
operates by unloading from the area being
reorganized (while applications can read
but cannot write to the area), reloading
into a shadow copy of that area (while applications
can read but cannot write to the original
copy), switching the applications' future
access from the original copy to the shadow
copy by exchanging the names of the data
sets, and then allowing read or write access
again.

To set the reference options:
- Specify the None radio button so that no deadline is set
on the reorganization. The reorganization
will run until it terminates with a successful
completion, or until it terminates with informational
or error messages.
- Specify the Point in time radio button to establish a reorganization
deadline by date or time.
- In the Date field, click the
push button to open a calendar and choose
a date. To exit the calendar, click the
again.
- In the Time field, specify a time in the form of HH:MM:SS, where HH is hours, MM is minutes, and SS is seconds. You can also select the up or
down arrows to spin through the available
choices for each time element.
- Specify the Elapsed time radio button to establish an amount of time
before reorganization should stop, regardless
of when you start the reorganization. Reorganization
starts when you click the OK push button on the main Reorganization window,
and stops after the amount of time specified
in the following fields.
- In the Days field, type a number of days that you want
to elapse before the reorganization of a
table space or index should stop.
- In the Hours field, type a number of hours, in addition
to days and minutes, that you want to elapse
before the reorganization of a table space
or index should stop. You can also select
the up or down arrows to spin through the
available choices for hours.
- In the Minutes field, type a number of minutes, in addition
to days and hours, that you want to elapse
before the reorganization of a table space
or index should stop. You can also select
the up or down arrows to spin through the
available choices for minutes.
- Specify the Leave objects in UTRO or UTUT state (ABEND) radio button to tell DB2 how to react in
an abnormal end or time out state. DB2 leaves
the object in a read only condition.
- Specify the Leave objects in RW state (TERM) radio button to tell DB2 how to react in
a time out state. In this case DB2 terminates
the reorganization process, issues some informational
messages and leaves the objects in a read
or write state.
-
Click OK to establish a deadline for reorganization.
[Return to reorganization of a table space
in DB2 for OS/390 Version 5]
[Return to reorganization of a table space
in DB2 for OS/390 Version 6]
[Return to reorganization of an index in
DB2 for OS/390 Version 5]
[Return to reorganization of an index in
DB2 for OS/390 Version 6]