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.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

Reorganizing DEFINE NO objects

You can reorganize an object that was defined with the DEFINE NO attribute. However, REORG PLUS does not support certain conditions.

The reorganization fails in the following situations:

  • You are reorganizing an object that was defined with the DEFINE NO attribute, but Db2 has not yet materialized the table space or index.
  • (SHRLEVEL CHANGE) While you are reorganizing a table space that contains at least one index that was defined with the DEFINE NO attribute, a row is inserted into one of the tables. The inserted row causes Db2 to define the VSAM data set for the index.

Related topics

Getting-started

Operational-considerations

 

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

REORG PLUS for DB2 11.2