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:

  1. 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.

  2. Specify the Point in time radio button to establish a reorganization deadline by date or time.
  3. 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.
  4. 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.

  5. 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.

  6. 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]