Skip to Content

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.

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.

 

Related topics

Getting started

Operational considerations

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.

 

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

REORG PLUS for DB2 13.1