Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Recoverability of reorganized table spaces

To ensure the recoverability of reorganized objects, REORG PLUS makes and registers full image copies of the table space objects.

If the value for ICTYPE is INCREMENTAL on the command or installation option, REORG PLUS also creates and registers incremental image copies of the table space objects. Updating the full copies provides the best performance. We recommend that you specify ICTYPE AUTO so that REORG PLUS can decide which type of copy is best.

Related topic

Online reorganization

If you specify ICTYPE AUTO, REORG PLUS determines whether to create incremental copies or update the full image copies based on certain criteria. REORG PLUS treats the option as if you specified ICTYPE UPDATE and updates the full copies when either of the following conditions exists:

  • The data sets are on DASD and one full copy data set exists for each partition that you are reorganizing.

  • You specify INLINE YES on the command or INLINECP=YES in the installation options module. In this case, REORG PLUS appends the updated pages to the full copy data sets, and you can put the copy data sets on tape.

    Warning

    Important

    If INLINE NO is in effect, do not put the copy data sets on tape because REORG PLUS updates the full copy data sets in place.

If you are reorganizing multiple partitions and using one copy data set, REORG PLUS treats ICTYPE AUTO as if you specified ICTYPE INCREMENTAL. You must have previously defined or dynamically allocated the incremental copy data sets. For more information, see Incremental copy data sets for SHRLEVEL CHANGE.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

REORG PLUS for DB2 13.1